% OF CHANGE

[BRRLL99]

Hi guys,

I'm trying to calculate % of change using multi-row formula

if close if less than open

then % diff should be shown in negative 

open	close
1,741	1,731
1,738	1,742
1,737	1,739
1,764	1,736
1,814	1,763

[Amol_Telore]

@BRRLL99 

This solution should work for you. Let me know if any doubts.

[Amol_Telore · Accepted solution]

@BRRLL99 

Here is the new formula if you want to show positive diff as well.

[BRRLL99]

hi,

i need both values,

if open > close then negative

if open < close then positive

[grazitti_sapna · Accepted solution]

Hi @BRRLL99, you can use this.

Thanks!