Hi everyone, I'm trying to make one of the variables (Currency) highlighted to the colour yellow on the Excel output if it doesn't equal to USD but it comes up as "Parse Error", please could I get some help?
Below are the screenshots. Thanks.
Change the column rule you have for only dollar to
[Currency] NOT IN ('USD',EUR','GBP','AUD')
Hi @ajaydhamrait
You should set-up a column rule in the table tool:
@ajaydhamrait The parse error in the formula tool is because of a mal-informed IF statement.
The general syntax is
If <condition> Then <Action>
else <Action>
endif
If you correct this the formula should work.
For conditional formatting in excel please check out this video.
https://cndro.com/how-to-conditionally-format-an-excel-csv-file-in-alteryx/
Hope this helps.
Best,
Jagdeesh
Hi @ajaydhamrait ,
Make it a column rule in the table tool :-)
Greetings,
Seb
That's great, thanks for your help. Another quick question, I want to do the same rule for another 200 currencies, is there a faster way to do this? @Luke_C
What exactly is the new rule?
If the variable Currency, does not equal to USD, EUR, GBP,...., & AUD, then highlight the Excel output cells the colour yellow. Any screenshots or data would be appreciated. Also, I need this to be a column rule.
There are roughly 200 currencies I need to do this for.
I agree with @Pingu. If you need to include 200 currencies though there may be a better way so you don't have to worry about maintaining a giant in clause. Some ideas that come to mind are joining a list of currencies to your data, flagging the fallouts, unioning them back, and using the flag field to drive the highlight. That way you can simply update the list if you have changes in the future.
If you want to go with the NOT IN clause, you can pass your list through a summarize tool to concatenate it for you to put into the formula
