topic Re: Formula Gap in QlikView

Formula Gap

Tue, 02 Dec 2014 18:14:28 GMT

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.

Tue, 02 Dec 2014 18:19:42 GMT

Is it a rounding issue?

fsimoes81 — Tue, 02 Dec 2014 18:24:24 GMT

Try:

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

Tue, 02 Dec 2014 18:28:01 GMT

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