calculate the value of a column based on previous column,

[chenyzhao]

hello everyone - i'm trying to create a cal in columns based on previous column. The original data shows the changes in each quarter like below:

Name	Q1	Q2	Q3
A	10000	0	1000
B	0	500	0
C	0	1000	1000
D	5000	-1000	0

The updated data should show the running balance based on previous and current quarter's value, desired output below:

Name	Q1	Q2	Q3
A	10000	10000	11000
B	0	500	500
C	0	1000	2000
D	5000	4000	4000

I could not find ideal solution for it, and any help is greatly appreciated!

[ShankerV · Accepted solution]

Hi @chenyzhao 

Based on the input shared, please make use of the Formula tool.

Select the column name as "Q2" in the drop down of the Filter tool

[Q1]+[Q2]

Select the column name as "Q3" in the drop down of the Filter tool

[Q2]+[Q3]

Note: Make sure the Q1, Q2 and Q3 are in integer datatype.

Many thanks

Shanker V

[binuacs · Accepted solution]

@chenyzhao One way of doing this with the running total tool

[chenyzhao]

perfect - thanks both!