Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a set analysis set up and was wondering if I could make an if statement out of the set analysis. Basically I want an if condition that checks to see if the value from the set analysis is greater than 0.
here's the set analysis:
sum({<FYEAR={$(vBenchYr)},QUARTER={'Q4'},Measure={'Shipped Qty'}>}(Value))
so if the sum of this set analysis value is greater then 0 then I want to do something
how would I do this if it can be done????
if (sum({<FYEAR={$(vBenchYr)},QUARTER={'Q4'},Measure={'Shipped Qty'}>}(Value))>0, '>0', '<=0')
if (sum({<FYEAR={$(vBenchYr)},QUARTER={'Q4'},Measure={'Shipped Qty'}>}(Value)) >0,
'A','B')
if ( sum({<FYEAR={$(vBenchYr)},QUARTER={'Q4'},Measure={'Shipped Qty'}>}(Value)) > 0 , TRUE , FALSE )