Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want a text box to return the Max(month) or latest month which has data in it.
The problem is when I use the max (month) in always returns 12/Dec because I have loaded in a mapping table with months/dates going out to 2015.
Is there a way of writing my expression such that Max(month) will return only the latest month for which revenues exist?
Thanks in advance!
Sure, you can do this with either set analysis or an IF statement. So, for example:
max(if(sum(Revenue)>0,month)
The following set analysis should also work:
max({<month={"=sum(Revenue)>0"}>} month)
Regards,