1 Reply Latest reply: Apr 18, 2013 3:40 PM by Steve Zagzebski RSS

    Expression - surpressing nulls

    Steve Zagzebski

      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.