3 Replies Latest reply: Apr 28, 2016 1:29 AM by Kumar Pramod RSS

    constant values

    Kumar Pramod

      hi all,

       

      I have created a table which displays the stats of 30 days, 7 days etc...

      metrics.png

       

      In the above pic, 30/60 days variance is dependent on 3rd and 4th column. I am using the below expression:

       

      Num(if(Metrics='Invitations',((count({$<CanonicalDate={">$(=date(Max(CanonicalDate)-30))<=$(=date(Max(CanonicalDate)))"}, DateType= {'invitation'},

        client_id= {'20'}>} invitation_id))

        -

        (count({$<CanonicalDate={">$(=date(Max(CanonicalDate)-60))<=$(=date(Max(CanonicalDate)-30))"}, DateType= {'invitation'},

        client_id= {'20'}>} invitation_id)))

      /

        (count({$<CanonicalDate={">$(=date(Max(CanonicalDate)-60))<=$(=date(Max(CanonicalDate)-30))"}, DateType= {'invitation'},

        client_id= {'20'}>} invitation_id)),

      if(Metrics='Landing Page Hits',((count({$<CanonicalDate={">$(=date(Max(CanonicalDate)-30))<=$(=date(Max(CanonicalDate)))"}, DateType= {'accessed'},

        client_id= {'20'}>} invitation_id))

        -

        (count({$<CanonicalDate={">$(=date(Max(CanonicalDate)-60))<=$(=date(Max(CanonicalDate)-30))"}, DateType= {'accessed'},

        client_id= {'20'}>} invitation_id)))

        /

        (count({$<CanonicalDate={">$(=date(Max(CanonicalDate)-60))<=$(=date(Max(CanonicalDate)-30))"}, DateType= {'accessed'},

        client_id= {'20'}>} invitation_id))

       

      Now i need to display 100% in the last column if the 3rd column value is zero.

       

      How can i achieve this?

       

      Regards,

      Pramod