sum over count giving different result than what it should be

[#1]

Hi All,

I have an expression like below

sum(calltime) / count(IncidentID)

In the same chart The individual expression sum(calltime)  is giving me 515224 and individual expression count(IncidentID) is giving me 42861. This means that the expression should give me 515224 / 42861 = 12.02.

However The Qlikview expression sum(calltime) / count(IncidentID) is giving me 0.0083478016685541 value. I am not sure where is this value coming from.

There is no other table attached with this table at the moment

Here is the sample QV document

Regards

Arif

[#2]

Hi Syed,

Problem because of format of "calltime"..

In chart, if you change number format from "Expression default" to number with 2 decimal.

Its giving 357.7...

So 0.008347 is right one..

Find attachment. It may help you..

Karthik