Divide time value with time value

[#1]

Hi

I am trying to divide one Time value with another Time value but QV retuns the wrong answer

I use this expression in my calculation
Time((sum(POPITI * DJMAQT)/1000)) / Time((max(DJRGDT_TM_Timestamp) - min(DJRGDT_TM_Timestamp) - sum(OprTime)))

But if I split the 2 Time values different parst then I get the right answer
Time((sum(POPITI * DJMAQT)/1000)) then will QV return -> 00:18:39 as expected
and when I use
Time((max(DJRGDT_TM_Timestamp) - min(DJRGDT_TM_Timestamp) - sum(OprTime))) then will QV return -> 01:06:15 as expected

But when I try to divide the to fields in QV in one calculation then I get the wrong strange answer -> -0,006633...?!?

The right decimal answer should be 00:18:39 / 01:06:15 > 0,281509 (tested in MS Excel)
(the answer is an KPI figure count for our company)

Thanx for any replies
// Daniel

[#2]

hi,

can you post an example

Nimish

[sathishkumar_go]

Hi Daniel

Can u share any example for ur data format.

-Sathish

[#4 · Accepted solution]

Hi
I manage to solve the problem,. It was related to the database relations that created the problem.