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 .....




      FInancial Year

      Period code





      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....