1 Reply Latest reply: Sep 18, 2017 1:13 PM by Vishwarath Nagaraju RSS

    set analysis

    Ronit Kanfi

      I need to show the income of last month.

      I have:

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

      once vMonthCal==num(Month(today()))-1

      and yet when i pick another quarter, the numbers change and not remain the numbers of the previous month.

      How do I fix it..?