Running Total & Reverse Running Total in separate columns

Question
1

Hellos,
I have a scenario where I wish to have both running total and reverse running total of a field “duration” , the moment I sort in descending order the sort changes.

Template Task Name TS Duration Total Duration
Provide contact list to EA 01 0 0
Add contact Number to Director Phone 02 0 0
Fill the onboarding Form 03 0 0
Introduction to reporting manager director rani madam 04 0 0
introduction of organization 05 0 0
Provide Email ID 06 0 0
provide Punching & HR1 Login 07 3 3
Any traning session of QB if needed 08 3 6
Provide Appointment letter 09 30 36
Trigger : If recruited by ‘external Recruiter’ complete This 10 0 36
Trigger : If recruited by ‘Internal Reference’ complete This 11 0 36
Hired through Portal no payment needed 12 0 36
2

I’m not sure what you mean by ‘reverse running total’. Please clarify, ideally with an example of input and desired output.

3

HI Andy,

Sorry my bad , basically total but in reverse , see example , duration column is added

Template Task Name TS Duration Running Total Duration Reverse Running Total Duration
Provide contact list to EA 1 0.00 0.0 42.04
Add contact Number to Director Phone 2 2.0 2.0 42.04
Fill the onboarding Form 3 3.54 5.54 40.04
Introduction to reporting manager director rani madam 4 3.5 9.04 36.5
introduction of organization 5 0.0 9.04 33.0
Provide Email ID 6 0.0 9.04 33.0
provide Punching & HR1 Login 7 3.0 12.04 33.0
Any traning session of QB if needed 8
Provide Appointment letter 9
Trigger : If recruited by ‘external Recruiter’ complete This 10 0.0 12.04 30.0
Trigger : If recruited by ‘Internal Reference’ complete This 11 0.0 12.04 30.0
Hired through Portal no payment needed 12 30.00 42.04 30.0
4

@prashant

Is this what you were looking for?

image
image812×751 70.9 KB

Transform file.
RunningTotalandReverseRunningTotal.transform (4.7 KB)

1 Like
5

Dude you rock ! Precisely what I wanted ! Thank you