Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

IF Formula

RanjanKT
8 - Asteroid

May i know what is wrong with the below formula.

 

Could some on help in correcting it.

 

clipboard_image_0.png

if [TotalValueOfPotentialSale]<"100000" then "1. < 100k" elseif [TotalValueOfPotentialSale]>="1000000" then "5.=or>1 Million" elseif [TotalValueOfPotentialSale]>="100000" AND [TotalValueOfPotentialSale]<"250000" then "2.100k-<250k" elseif [TotalValueOfPotentialSale]>= "250000" AND [TotalValueOfPotentialSale]<"500000" then "3.250k-<500k" elseif [TotalValueOfPotentialSale]>= "500000" AND [TotalValueOfPotentialSale]<"1000000" then "4.500k- < 1 Million" else ""
endif

2 REPLIES 2
Srini_Advik
7 - Meteor

Check the Data type of 'TotalvalueofP....' change from string to integer. also check remove "" Quotes from the number. Please refer the formula below.

 

if [TotalValueOfPotentialSale]<100000 then "1. < 100k"

RanjanKT
8 - Asteroid
Thanks
Labels
Top Solution Authors