community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Change values of a column based on certain rules.

data example1.jpg

 

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?

Alteryx Partner

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

Aurora

hi @gurpreet-singh 

 

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

 

Dan

thank you @afv2688 

Labels