Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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