1 Reply Latest reply: Mar 22, 2013 8:03 AM by Sushil Kumar RSS

    Suppress row when expression returns null

      Hi,

       

      I have to implement the following logic

       

      Roll Rate = Current Month(Amount1)/Previous Month(Amount2).

       

      This has to be displayed for 13 months. I have implemented the below expression

       

      sum({< [Month Start Number] = {"<=$(=max([Month Start Number])) > $(=max([Month Start Number])-395)"}>}Amount1) /

      Above(sum({<[Month Start Number]={"<=$(=max([Month Start Number])-30)>$(=max([Month Start Number])-426)"}>}Amount2))

       

      The expression is working but i am getting an extra row with null value since the expression returns null for one month. How can i suppress this row? I have tried  suppress null option but this is not working.

       

      Thanks