Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

IF contains forumla for positive and negative values

geeklarokcmie
8 - Asteroid
Column AAtypeAmnt
123GPP40.56
456CBB40.51
789GPP30.0
101CBB80.00
102AAP9.00
103AKS7.00

 

What can be the forumla or tool to use  for the below requirement:

 

The net ‘Amnt’  where the net equals any Atype containing GPP and CBB minus all others

 

I have used the below formula but I only get negative values - I need to get both positive and negative values

 

IF [Atype] in ('GPP','CBB') then [Amnt]
ELSE -1*[Amnt] ENDIF

1 REPLY 1
Luke_C
17 - Castor

Hi @geeklarokcmie 

 

It seems to be working correctly? Can you share the expected output for each column?

Luke_C_0-1663689320352.png

 

 

Labels