Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..?
May be this? Quarter is like your Quarter field name. If your name is different replace with your actual Quarterfieldname.
=num(sum({<Month_Num={$(vMonthCal)},Year={2017}, Quarter=>} [TRUEPRICE]),'#,##0 ')