Dear Community , I have this requirement of using running total . Group By Text Text Amount CommentA100Matching B200Not Matching C300Matching A-100Matching B200Not Matching C-300Matching I would like to comment the rows if they are leading to zero by using Running total . Any help . Thanks .

I think I finally got it (or at least I hope so :D )! Let's try this: Workflow Sample attached. Let me know if this works! Best Alex

Running total

praneshsapmm

Dear Community ,

I have this requirement of using running total .

Group By Text

Text	Amount	Comment
A	100	Matching
B	200	Not Matching
C	300	Matching
A	-100	Matching
B	200	Not Matching
C	-300	Matching

I would like to comment the rows if they are leading to zero by using Running total .

Any help . Thanks .

Data Investigation

Accepted answers

grossal

I think I finally got it (or at least I hope so )! Let's try this:

Workflow Sample attached. Let me know if this works!

Best

Alex

2020-08-03-Running total-2.yxmd

All comments

wdavis

Hi @praneshsapmm

I have attached a workflow which should help you with this.

Using the Summarize Tool to create the Running Total. You can then use the Join Tool to join the summed amount back to the original dataset. Then finally use a Formula Tool to create an IF statement which will apply the comments.

Let me know if this works for you!

Kind Regards

Will

Running Total.yxmd

praneshsapmm

Hello ,

Thanks for the answer.

But i would like to do this by running total tool .

Because if i use summerize tool , rows adding upto zero will be suppressed and cannot be commented as shown below :

Group By Text

Text	Amount	Comment
A	100	Matching
A	-100	Matching
B	200	Not Matching
C	-300	Matching
A	-100	Not Matching
A	-300	Not Matching

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703