4 Replies Latest reply: Sep 5, 2016 11:35 PM by Virendra Chawra RSS

    current vs previous vs same period last year

    Virendra Chawra

      I have a requirement and for that i have a table .....

       

      KPI

      -----------

      FInancial Year

      Period code

      Count

      Booking

       

       

      Now as per table i want 3 expression

      (1) Current period ---that is just the value of field Count for selected Period COde

       

      (2) Previous period-  please suggest

           sum({<Period code ={Num(Period Code)-1)}>}Count)               ///but not working ...

       

      (3) Same period last year ---please suggest how to generate a set expression for the same....

       

       

       

      please suggest....