Alteryx Designer Desktop Discussions

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

Conditional formula query

NMorgan
7 - Meteor

Hi all,

 

Appreciate this is probably a basic question and I'm missing something.

 

I've been working on the Prep a Shoe List challenge (link below) and I tried to use a formula to populate a new Comments column based on the number of colours across 3 columns. For some reason, I always get the same result "3 Colours" when I use the below formula, even where only 1 column is populated and I'd expect the result to be 1 Colour.

 

Challenge #289: Prep a Shoe List - Alteryx Community

 

IF NOT IsNull([Colour3]) THEN "3 Colours"

ELSEIF NOT IsNull([Colour2]) THEN "2 Colours"

ELSE "1 Colour"

ENDIF

 

Thanks

 

Neil

2 REPLIES 2
RSreeSurya
9 - Comet

Hi,

 

Using empty instead of null should give expected results.

 

RNSupraja_0-1685020645421.png

 

NMorgan
7 - Meteor

That's great, thanks very much :)

Labels