Assign cumulative sum of column to new column

Help Activities
1

Greetings,

I am looking for assistance on getting the cumulative sum of ColumnA and assigning it as a value in ColumnB. Example:

image

2

try this @calvin.tan
Sequence2.xaml (9.7 KB)
input
image
result
image

image
image670×596 16.5 KB

3

@calvin.tan
Use Read Range to read data.
Use Add column Activity to add one more column.
Use loop through Index and For first time Assign new column First row.
For other rows-> assign new column → Current Row plus previous sum.

4

@calvin.tan

Welcome to the community

You can acheive this using excel formula

Follow the steps

  1. Use write cell on cell "B2" and give the value as "=Sum($A$2:$A2)"
  2. now use autofill range and give the range as "B2:B6" you can try by only give "B2" as well

Cheers

5

Hii @calvin.tan ,
Give a try to this one,

Main.zip (2.1 KB)

image

Cheers,

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.