Problem in Sum()

[rash_611]

Hi All,

i have derived downtime field as

if(SYSDOWNMINS>1440,(interval(Timestamp(DATETIME)-DayStart( DATETIME),'mm')),SYSDOWNMINS)

when we are giving sum(downtime) in front end we are getting 1384.49.... why is this can any one help me....

Regards,

Grace

[anbu1984]

Can you add sample qvw.

[rash_611]

PFA

[anbu1984]

Change format of downtime to Number. Check attached qvw

[danieloberbilli]

there seems to be an issue with the last 3 numbers:

downtime	sum(downtime)
	1384.4965277778
1366	1366
10	10
7	7
1055	0.73263888889051
700	0.48611111110949
400	0.27777777777374

[marcus_sommer]

Maybe there is a problem with rounding: http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors

- Marcus

[MarcoWedel]

you are adding days and minutes.

interval(Timestamp(DATETIME)-DayStart( DATETIME),'mm'))

gives you an interval with a textual representation in minutes but an underlying numerical value of days.

So you could try:

if(SYSDOWNMINS>1440,Round(Frac(DATETIME)*60),SYSDOWNMINS) as downtime

hope this helps

regards

Marco