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

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Ranged Formula tool issue

Madzy
7 - Meteor

Hey I am having an issue with my formula tool regarding on doing a ranged formula. 

IF [Days] >= "0" AND [Days] < "30" THEN
"0 - 30 Days"
elseif [Days] >= "30" AND [Days] < "60" THEN
"30 - 60 Days"
elseif [Days] >= "60" AND [Days] < "90" THEN
"60 - 90 Days"
elseif [Days] >= "90" THEN
"Greater 90 Days"
else Null()
endif

This is y formula but it is spouting out 

Madzy_1-1682948334132.png

Where I want those to be > 90 days. Any suggestions? 

BTW The days columns is being generated by a formula --> DateTimeDiff(DateTimeToday(),[Invoice Date],'days')

1 REPLY 1
DataNath
17 - Castor
17 - Castor

Hey @Madzy, the issue here lies with using the wrong data types. When making your [Days] field, make sure it's numeric (options in the dropdown):

 

DataNath_0-1682948757918.png

 

Then, for your [>= Days] field, write this without the quotes around the numbers:

 

IF [Days] >= 0 AND [Days] < 30 THEN
"0 - 30 Days"
elseif [Days] >= 30 AND [Days] < 60 THEN
"30 - 60 Days"
elseif [Days] >= 60 AND [Days] < 90 THEN
"60 - 90 Days"
elseif [Days] >= 90 THEN
"Greater 90 Days"
else Null()
endif

 

DataNath_1-1682948828677.png

Labels