Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pretty simply straight table with 3 dimensions and the following expression;
=if(right([Incurred Year Month],2)=[Renewal Month]
,if(above([Group ID])=[Group ID]
,2,''),'')
The epxression works but I am trying to get figure out a way to surpress the line of data if there is no value. It keeps showing every line even if there is no value in it and I have checked the "Supress When value is null" checkbox for each dimension.
sorry - i realized I can't use "above" in this case. It wouldn't make sense.