Change values of a column based on certain rules.

[gurpreet-singh]

Hi Community,

(Please see screen shot for data structure understanding)

I would like to change the [Value] column to absolute values (as some of the numbers are negative) based on the rules below:

1. Any Item that is below “Salaire Brut” and [RecordID] should be greater than that of “Salaire Brut”’s [RecordID]’s

I hope this makes sense?

[afv2688 · Accepted solution]

Hello @gurpreet-singh ,

For that you would need to use the multi row formula twice:

First one could be something like:

IF [F2] =  "Salaire Brut" THEN [Row-1:New_column]+1 ELSE  [Row-1:New_column] ENDIF

And the second would be:

IF [F2] !=  "Salaire Brut" AND [New_column] > 0 THEN ABS([Value]) ELSE [Value] ENDIF

Cheers

[danilang]

hi @gurpreet-singh 

Can you post an example of what your required output would be?

Dan

[gurpreet-singh]

thank you @afv2688