Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a formula written below in a text object.
num(((sum([Weekly Hours])/8/count(DISTINCT(EmployeeName&Time)))),'#,##0.0')
this results in 194.9 (Year)
I have the same formula in a pivot table as per below
sum([Weekly Hours])/8/count(DISTINCT(EmployeeName)) (Time is a group dimension (Year, Quarter, Month, etc.))
this result is 199.9 (Year)
Does anyone know why I am getting this gap?
It looks like when I filter the Time group, my calculation in the text box is slightly off when I drill down to any particular month.
This worked...
It seemed to be a rounding issue...
num((num(round(sum([Weekly Hours])/8,1),'#,##0'))/num(count(DISTINCT([EmployeeName])),'#,##0'),'#,##0.0')
Is it a rounding issue?
Try:
Sum(Aggr(sum([Weekly Hours])/8/count(DISTINCT(EmployeeName)),Year, Quarter, Month))
This worked...
It seemed to be a rounding issue...
num((num(round(sum([Weekly Hours])/8,1),'#,##0'))/num(count(DISTINCT([EmployeeName])),'#,##0'),'#,##0.0')