Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
This expression isn't working
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,
Wow, it works now.
Thanks a lot for your hep!!!