6 Replies Latest reply on Aug 29, 2016 1:09 AM by Govind Ramchetty

    current Date sum vs Previouse year sum

    Govind Ramchetty

      Dear all,

      How can I compare current parameter date sum and same period last year sum.

       

      E.g...I tired but it showing error.I know this is not syntax. Can you please help me.How can I achive.

       

      IIF([FDate],sum(total))>IIF([LDate],sum(total))

       

       

      My requirement is I have to display arrow up or down arrow. Based on current selected date vs Same period last year.

       

      Thanks

      Govind R