Can this be converted to Set Analysis?
if(SUM(EXTENDED_RETAIL) >=500, sum(EXTENDED_RETAIL)*.05, sum(EXTENDED_RETAIL)*.02 )
No, but you could use the statement in your script and create an extra field for the outcome so you no longer have to do the calculation in your front-end.
no set expression, but maybe helpful:
The " + " in the set equation represent the "OR" condition?
In your case your comparing the results after the Aggr so you need calculate the sun() in the script then you could use the same in set analysis
Retrieving data ...