adding months in a variable

[rcorcoran]

Hi I have a variable I am using to show current monthminus1 data and it works fine

=floor(AddMonths(vnp_CurrentMonth, -1))

the vnp_currentMonth is a variable that takes the selected month and is used in the above:

=floor(MonthStart(vSelectedYearMonth))

so the above will show data for the selected month minus one month.  I want a variable that will add the current month-1 the current month-2 and the current month-3 so for instance if January is selected it will add the data for Oct, Nov and Dec and display them.

The full expression that uses this for your information is:

NUM(SUM({<[PA2]={21}, DateNo={'$(vnp_CurrentMonthMinus1)'}, ReferredMM=, YearMonth=>}ActualValue), '#,##0'),

Any help appreciated

[rcorcoran]

Actually sorry I just figured it out straight after posting this:

NUM(SUM({<[PA2]={21}, DateNo={'$(vnp_CurrentMonthMinus1)','$(vnp_CurrentMonthMinus2)','$(vnp_CurrentMonthMinus3)'}, ReferredMM=, YearMonth=>}ActualValue), '#,##0'),