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

Custom Formula Functions

jboschee
8 - Asteroid

Hi all,

 

I'm trying to create a formula that will pull numbers from certain fields and multiply them.   Something like this:

 

If X = Y then (Price*Pack*Units in Pack)

If X = Z then (Price*Pack)

 

Any help would be appreciated.

 

Thanks!

4 REPLIES 4
gnans19
11 - Bolide

@jboschee

 

Should be straight formula using If

 

If X=Y THEN [Price]*[Units in Pack] ELSE [Price]*[Pack] ENDIF

 

4.png

 

 

jboschee
8 - Asteroid

That's what I originally went with, but I'm getting an error for unknown variable for Y

gnans19
11 - Bolide

May be you have space in column name. Try to use square bracket [Y]

jboschee
8 - Asteroid

I think I need it to say if column X contains Y then 

Labels