Nested If-Else condition not working

madhurinani

I have used the below logic for nested if else condition.

I want to create a logic which says that if none of the conditions match the criteria, it should show as "marginal"

IF [Change]=0 THEN "No change"
ELSEIF [PQ FD %]>15 and [Current FD Own %]<15 then "Change below 15%"
ELSEIF [PQ FD %]>20 and [Current FD Own %]<20 then "Change below 20%"
ELSEIF [PQ FD %]>25 and [Current FD Own %]<25 then "Change below 25%"
ELSEIF [PQ FD %]>50 and [Current FD Own %]<50 then "Change below 50%"
ELSEIF [PQ FD %]<15 and [Current FD Own %]>15 then "Change above 15%"
ELSEIF [PQ FD %]<20 and [Current FD Own %]>20 then "Change above 20%"
ELSEIF [PQ FD %]<25 and [Current FD Own %]>25 then "Change above 25%"
ELSEIF [PQ FD %]<50 and [Current FD Own %]>50 then "Change above 50%"
ELSEIF [PQ FD %]=0 and [Current FD Own %]>0 then "New Investment"
ELSEIF [PQ FD %]>0 and [Current FD Own %]="" then "Liquidation"
else "marginal"
ENDIF

But somehow It is not working properly. As the highlighted Category column show ideally display as "marginal"

Any help would be amazing.

Thanks!

2022-07-04_15-44-27.png

DataNath

Hey @madhurinani, what are you checking for in this last line?

ELSEIF [PQ FD %]>0 and [Current FD Own %]="" then "Liquidation"

Where you have ="", Alteryx is checking for a blank string value because of the quotation marks, whereas all of your other conditions are based on numeric checks. Are you looking for a blank/null here? If so, you could perhaps try using AND isempty([Current FD Own %]) or AND isnull([Current FD Own %]).