something wrong in Average totals

[rmuhammad]

Hi All

when I do totals for Avg it is not calculating correctly. Cant find logic how are these calculated. How can I fix this? please help. see attached sample app

[vishsaggi · Accepted solution]

Try this in your expr:

= AVG(Aggr(avg(HourlyRate), YEAR, DEPT, [EMP Start Dt]))

[sunny_talwar]

Create your calculated dimension in the script and try this expression

Avg(Aggr(Avg(HourlyRate), YEAR, DEPT, [service yr]))

[rmuhammad]

Thanks. it works