Previous 12 months expression

[yvonne-c]

I am using the following expression to calculate between two dates

Sum({<Date ={">=$(vStartDate)<=$(vEndDate)"}>} Price)

I also want to calculate the same period for the previous 12 months

I have tried the following expressions but cannot get them to work.

    Sum({<Date={"=Date>=addmonths(vStartDate,-12) and Date<=addmonths(vEndDate,-12)"}>} Price)

     Sum({$<Date ={">=$(=Num(AddMonths(vStartDate, -12)))<=$(=Num(AddMonths(vEndDate, -12)))"}>}Price)

Can anybody advise?

Thanks

[sunny_talwar]

What is the format of your date field? Also, are you making selection in Date or another date and time related fields?

[sunny_talwar · Accepted solution]

May be try this

Sum({<Date={"=Only({1} Date) >= AddMonths(vStartDate, -12) and Only({1} Date) <= AddMonths(vEndDate, -12)"}>} Price)

[yvonne-c]

Thanks Sunny

This one seems to be working