Convert if statement to Set Analysis

[#1]

Can this be converted to Set Analysis?

if(SUM(EXTENDED_RETAIL) >=500, sum(EXTENDED_RETAIL)*.05, sum(EXTENDED_RETAIL)*.02  )

[oknotsen]

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.

[MarcoWedel · Accepted solution]

no set expression, but maybe helpful:

SUM(EXTENDED_RETAIL)*(.05+(sum(EXTENDED_RETAIL)<500)*.03)

regards

Marco

[#4]

Marco,

The " + " in the set equation represent the "OR" condition?

Lyndon

[avinashelite]

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

[#6]

It works!