I have a collection. How can i write this code to be indexed so only that row is affected.
=IF(EQ(OTHER_EXPENSES___Explain__2.Toll_Fees_Request, "Denied"), 0, "")
Got it, Thanks
Hi Carlos, what appears to b missing is your INDEX statement is incomplete.
The INDEX statement should be INDEX(CollectionName.variablename,ROWindex). When using in a multiple ROW table you would use INDEX(CollectionName.variablename,ROW()) which means to use the variables from that line of the table instead of a specific row.
You calculation should look like
=IF(EQ(INDEX(OTHER_EXPENSES___Explain__2.Toll_Fees_Request,ROW()), "Denied"), 0, "")
So I was able to accomplish what I was wanting using this format.
=IF(INDEX(EQ(OTHER_EXPENSES___Explain__2.Toll_Fees_Request, "Denied"), 0, ""))
How, every time i click on the "add" I lose all my amounts for the expectation of the "Toll Fee" selection.
1. I fill in Other Expenses with "Baggage" and Other Amount with "10.00" as shown in Index1.png
2. I click on the "add" and I loose the "10.00" as shown on Index2.png
3. I fill both "10.00" and "20.00" and then I click on "Denied" and I get to keep the "10.00" the I loose the "20.00" to "0.00". This is what I wanting. As shown on Index 3.png
4. I click on "add" and I loose "10.00" but I get to keep the "0.00" As shown on Index4.png
5. So my goal is to keep all my amounts as shown on Index5.png without loosing any of the amount when clicking on the "add" button.
As Steve mentioned, the INDEX function still needs to be the innermost formula for the table/collection variables (see his example).
Your example has EQ inside of the INDEX meaning the EQ function will be applied before the index, which is not what you want.
The INDEX function tells it to retrieve a specific value from a list/collection, but in your examples EQ is being applied on the entire collection not the row.
Got it. Thanks