Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can this be converted to Set Analysis?
if(SUM(EXTENDED_RETAIL) >=500, sum(EXTENDED_RETAIL)*.05, sum(EXTENDED_RETAIL)*.02 )
no set expression, but maybe helpful:
SUM(EXTENDED_RETAIL)*(.05+(sum(EXTENDED_RETAIL)<500)*.03)
regards
Marco
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:
SUM(EXTENDED_RETAIL)*(.05+(sum(EXTENDED_RETAIL)<500)*.03)
regards
Marco
Marco,
The " + " in the set equation represent the "OR" condition?
Lyndon
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
It works!