Hi All,
Kindly let me know your thoughts on how to calculate the cumulative value based on the below scenario
A B C Amt
1 1 1 10
1 1 2 10
1 1 3 10
1 1 4 10
1 1 4 10
From the above data i would like to calculate the cumulative as below
A B C Amt
1 1 1 10
1 1 2 20
1 1 3 30
1 1 4 10
kindly let me know your thoughts
Thanks
Need to calculate cumulative value
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am
Post your rules / requirements for this calculation in words first rather than make people puzzle it out from your example. Which right now really does need an explanation.
If all you are talking about is a running total, then all you need is a stage variable in a transformer. If your last value in the output example needs to be 50 rather than 10 then that's a horse of a different color.
If all you are talking about is a running total, then all you need is a stage variable in a transformer. If your last value in the output example needs to be 50 rather than 10 then that's a horse of a different color.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers