Formula Gap

[#1]

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.

[#2]

Is it a rounding issue?

[fsimoes81]

Try:

Sum(Aggr(sum([Weekly Hours])/8/count(DISTINCT(EmployeeName)),Year, Quarter, Month))

[#4 · Accepted solution]

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')