I have one Parent id to that Actual value is 3 but same parent ID has 3 Subtasks so when i wrote Sum(Actual) i am getting 10 but problem is Sum (Parent Actual ) i should get only 3 as it has same project iD so my Total should be 10+3 =13.
but right now i am getting 10+9=19 which is wrong .
So how can i write it in back end Qlikview Script.
Yes , Basically in the example i have given 1 parent value is getting repeated for 3 times as it has 3 child.
My Numerator is Sum(Parent Actual) >>> right now i am getting 3+3+3=9 but i should get once per Parent. so i should get 3 as my numerator as Parent is same . (Basically it should sum only once per Parent)
Sum(Parent Actual) as Numerator----It should come only once per Parent ( this how can i write in back end script ?)
Sum(Actual) as Denominator -- no problem as i am summing at child level it comes correctly.