Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
i have a Question, my tables has 3 Values
Employee , ExValue
1, 11%
2, 37,9%
3, 22,3 %
for the Field: ExValue i used the following calculation:
(((sum({<Flag1 ={1}>}[VAL Sales])/(sum({<Flag2 ={1}>}Bugdet)-sum({<Flag3 ={1}>}Holiday))) / (PlanValue)) *100)
now my problem:
i want to show the Avg of Values (11%, 37,9%, 22,3%) =23,73% , with above expression i have always the message: nested aggregation not allowed.
Does anybody know how to solve this issue?
Thanks a lot
Beck
Hi Beck,
You can not use aggragate functions like avg(sum(...)). You should combine with aggr() function.
avg(aggr((((sum({<Flag1 ={1}>}[VAL Sales])/(sum({<Flag2 ={1}>}Bugdet)-sum({<Flag3 ={1}>}Holiday))) / (PlanValue)) *100),Employee))
Can you give a try on the below expression:
Avg(Aggr((((sum({<Flag1 ={1}>}[VAL Sales])/(sum({<Flag2 ={1}>}Bugdet)-sum({<Flag3 ={1}>}Holiday))) / (PlanValue)) *100),Employee))
Hi Beck,
You can not use aggragate functions like avg(sum(...)). You should combine with aggr() function.
avg(aggr((((sum({<Flag1 ={1}>}[VAL Sales])/(sum({<Flag2 ={1}>}Bugdet)-sum({<Flag3 ={1}>}Holiday))) / (PlanValue)) *100),Employee))
Can you give a try on the below expression:
Avg(Aggr((((sum({<Flag1 ={1}>}[VAL Sales])/(sum({<Flag2 ={1}>}Bugdet)-sum({<Flag3 ={1}>}Holiday))) / (PlanValue)) *100),Employee))
Hi Kaanerisen thanks a lot for your time and help
Hi Trdandamudi,
thanks a lot for your help and time