Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created a variable to calculate the current financial month;
vFINMNT =
=num(month(AddMonths(today(),-3)))
I now need to create an expression that calculates the current months sales without selecting the financial month but having difficulty creating it, can anyone help?
TIA
Do you have a MonthNum field in your application?
Yes I have FINMONTH
May be this
Sum({<FINMONTH = {'$(=vFINMNT)'}>}Sales)