addmonths query

[hopkinsc]

Hi All

i cant get something working.

If a user was to select a fiscal year of 2016, then i want the text box to show the sum(sales) but for the previous year but the following month based on todays date.

=Sum({<[Fiscal Year]= {$(=max([Fiscal Year])-1)}, Month={$(=Date(Date#(Month(today())+1, 'MM'),'MMM'))}>}[Sales])

Can anyone help?

[sunny_talwar]

May be this:

=Sum({<[Fiscal Year] = {$(=Max([Fiscal Year])-1)}, Month={'$(=Month(AddMonths(Today(), 1)))'}>} Sales)

[Anonymous]

did you check this?

Current Month v. Same Month Last Year

[MayilVahanan]

Hi

Try like this

=Sum({<[Fiscal Year] = {$(=Max([Fiscal Year])-1)}, Month={'$(=Month(AddMonths(Today(), 1)))'}>} Sales)

[hopkinsc]

that doesnt work but i think its because my month field is in the number format. i.e.

1

2

3

4

5

etc

[sunny_talwar · Accepted solution]

Try this:

=Sum({<[Fiscal Year] = {$(=Max([Fiscal Year])-1)}, Month={'$(=Num(Month(AddMonths(Today(), 1))))'}>} Sales)

[MayilVahanan]

Hi

Then Change Month to Number by using Num() function

[MayilVahanan]

Hi

Sunny is too fast to reply

Please follow sunny suggestion.