Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have this IF statement which works:
IF(month(DATE) < 3 OR month(DATE) = 12, sum(IM*GBP),'no data')
How would I transform it into set analysis? Is it possible?
Also, instead of having 'no data', is it possible to just not display the row at all?
Thanks
That can't be rewritten to a set analysis expression. If you rewrite it to IF(month(DATE) < 3 OR month(DATE) = 12, sum(IM*GBP)) and check the option Suppress Zero-Values and Suppress Missing on the Presentation tab of the properties window then the row won't be displayed (unless another expression on that row does have a value).
Thanks for help. That's the problem, other expressions have values so the whole row is displayed and checking Suppress boxes doesn't work.