nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to subtract values from previous row values?

UserID16644

Hi all

Can someone help me how to formulate a formula that would subtract Column 2 to the previous value in Column 1? It should look like this. The column Equation only shows how the subtraction of values should be.TIA

Accepted answers

David_Burnham

Then you need some conditional logic. Something like:

If( :Column 2 != Lag( :Column 2, 1 ) | Row() == 1,
	:Column 1,
	:Column 2 - Lag( :Column 1, 1 )
)

All comments

David_Burnham

You can use the LAG function:

:Column 1 - Lag( :Column 2, 1 )

UserID16644

Hi, how about if I wanted to retain the row value before the values in Column 2 changes? Like this one

David_Burnham

Then you need some conditional logic. Something like:

If( :Column 2 != Lag( :Column 2, 1 ) | Row() == 1,
	:Column 1,
	:Column 2 - Lag( :Column 1, 1 )
)

UserID16644

Hi, I have a follow up question tho. What if I needed to add the values from Column 1 to be subtracted in Column 2?

For example,

Column 1	Column 2	Result
10	20	10
2	20	8
5	20	3
3	20	0
2	15	5
1	15	13
3	15	12
4	15	5