Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this in your expr:
= AVG(Aggr(avg(HourlyRate), YEAR, DEPT, [EMP Start Dt]))
Try this in your expr:
= AVG(Aggr(avg(HourlyRate), YEAR, DEPT, [EMP Start Dt]))
Create your calculated dimension in the script and try this expression
Avg(Aggr(Avg(HourlyRate), YEAR, DEPT, [service yr]))
Thanks. it works