Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Formula HELP

rrahu07
8 - Asteroid

I am trying to use this formula. but I am getting error. 

if [Account Group] = "CAPL CE"
or
"COMPTR"
or
"SW SEH"
Then [Fixed Asset After Adjustment] else 0

 

rrahu07_0-1645471945080.png

Can someone please help me to fix this formula?

4 REPLIES 4
ChrisTX
15 - Aurora

if [Account Group] IN ("CAPL CE", "COMPTR", "SW SEH")
Then [Fixed Asset After Adjustment] else 0 ENDIF

atcodedog05
22 - Nova
22 - Nova

Hi @rrahu07 

 

Formula should be

 

if [Account Group] In ("CAPL CE","COMPTR","SW SEH")
Then [Fixed Asset After Adjustment]

Else 0 Endif

 

atcodedog05_0-1645472204756.png

 

Hope this helps : )

rrahu07
8 - Asteroid

YOU ARE AMAZING!!! Thanks.

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @rrahu07 

Cheers and have a nice day!

Labels