In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop 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
17 - Castor
17 - Castor

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
Top Solution Authors