Addmonths in Set Analysis ( next 3 months)

[#1]

Hello,

Guys need your help!

I want to create an expression with average of next three months. I tried to use this one with addmonths function, but it's not working

Avg({<Month_name={">=$(=Date(addmonths(Month_name,1),'MMM'))<=$(=Date(addmonths(Month_name,3),'MMM'))"}>} Values)

Please help!

[PrashantSangle]

Hi,

Try below expression

=Avg({<Month_Date={">=$(=Date(addmonths(Month_Date,1),'MMM-YY'))<=$(=Date(addmonths(Month_Date,3),'MMM-YY'))"},Month_name=>} Bench_Data)

Regards

[#3]

This expression isn't working

[PrashantSangle · Accepted solution]

Hi,

I have tested data let me know what was your expecting output.

It is working at my end.

testCase:

Selected Month : Mar

Employee Name : Itojqj Tygnss

Expected Avg for next 3 month is sum(Apr,May,Jun)/3

Result :

Then Bench_data for Apr,May jun is 1.94

and Avg is 0.64666

Please find attached apps.

Regards,

[#5]

Wow, it works now.

Thanks a lot for your hep!!!