From IF Statement to Set Analysis

[#1]

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

[Gysbert_Wassenaar]

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).

[#3]

Thanks for help. That's the problem, other expressions have values so the whole row is displayed and checking Suppress boxes doesn't work.