5 Replies Latest reply: Sep 18, 2017 2:50 AM by Vsevolod Khassanov 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