Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Discussions

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

Parse Error

mihir_mir_jb
8 - Asteroid

Hi,

 

I am getting the attached error while inputting IF function.

 

The ask is to put Yes if the per person expense is greater than 50 and No if the pp expense is less than 50.

 

Can you please help how do I resolve this.

 

Thanks for your help in advance.

4 REPLIES 4
JosephSerpis
16 - Nebula
16 - Nebula

Hi @mihir_mir_jb you don't need the = at the start of the formula.

RolandSchubert
16 - Nebula
16 - Nebula

Hi @mihir_mir_jb ,

 

try:

 

IF ([Per Person Expense]) <= 50 THEN
'Yes'
ELSE
'No'
ENDIF

 

Best,

 

Roland

mihir_mir_jb
8 - Asteroid

Thank you very much @RolandSchbert, it worked.

zakellaoui
Alteryx Alumni (Retired)

Hello @mihir_mir_jb , Thanks for posting your question in the community, 

Please check the answer as accepted solution so that other users can benefit from it 🙂 

 

Cheers, 

Zak

 

Labels