I have loaded a table into my script with the columns 'Condition' and 'Target'. How can I check to see if my 'Condition' value equals filters selected?
For example:
Filters are SubRegion, Quarter, and GBU. So if I have 'Brazil' selected for SubRegion, 'Q2' selected for Quarter, and 'ABS' selected for GBU, how do I match it to my Condition value that is 'BrazilQ2ABS'?
To maintain conditions as a data island, a 'select in field' action should work. I don't know why it would have stopped working. Did you refresh the document with new data ? if you put '=only(SubRegion)&only(Quarters)&only(GBU)' in a text box does it still return a legitimate value ?
yes it works perfectly in a text box. I did refresh the document with new data but the table format and column headers stayed the same. I was able to create a workaround using fieldvalue and field index. I put my expression in a variable and it works great. But I now have a new issue - how do I use my variable in an expression that only recognizes filters from those three fields (SubRegion, Quarter, GBU) or no filters at all? When I use sum with exclusions the variable returns the wrong value (ex sum({<field1=, field2=, etc.>} vTarget)
.png "Former Employee"){kind=icon}