Calculating current month sales

[#1]

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

[sunny_talwar]

Do you have a MonthNum field in your application?

[#3]

Yes I have FINMONTH

[sunny_talwar]

May be this

Sum({<FINMONTH = {'$(=vFINMNT)'}>}Sales)