Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
I manage to solve the problem,. It was related to the database relations that created the problem.
hi,
can you post an example
Nimish
Hi Daniel
Can u share any example for ur data format.
-Sathish
Hi
I manage to solve the problem,. It was related to the database relations that created the problem.