3 Replies Latest reply: May 16, 2017 7:54 AM by Onno van Knotsenburg RSS

    set analysis

    Ronit Kanfi

      HI,

       

      I have the following variable:

      vIncome=num(sum({<Month_Num={4},Year={2017}>} [TRUEPRICE]),'#,##0 ')

      However, I do not want to change each month the "month_num" (which needs to the previous month).

      What I need instead is

      num(Month(today()))-1


      How do I combine them?

      Thank you,

      Ronit