Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Promote Discussions

Find answers, ask questions, and share expertise about Alteryx Promote.

Why Doesnt this work?

jjdenha
5 - Atom

IF [Length of Service1] <= 90 THEN '0-3 Months' elseif [Length of Service1] > 90 and [Length of Service1] <=180 THEN '3-6 Months' ELSEif [Length of Service1]> 180 and [Length of Service1] <= 365 then '6-12 Months' elseif [Length of Service1] >365 and [Length of Service1] <= 1095 then '1-3 Years' else if [Length of Service1] >1095 and [Length of Service1] <= 2190 then '3-5 Years' elseif [Length of Service1] >2190 and [Length of Service1] <= 3650 then '5-10 Years' elseif [Length of Service1] > 3650 and [Length of Service1] <= 5475 then '10-15 Years' else '15+ Years' ENDIF

7 REPLIES 7
DavidP
16 - Nebula
16 - Nebula

Problem highlighted in blue  - remove the space.

 

DavidP_0-1584401425765.png

 

jjdenha
5 - Atom

jjdenha_0-1584407868538.png

 

Why is it returning a Null?

AbhilashR
14 - Magnetar
14 - Magnetar

@jjdenha - can you modify the [Length of Service 1] fields datatype to DOUBLE and test? If you still get a null, could you share a screenshot of the [Length of Service 1] field which is causing the null?

jjdenha
5 - Atom

Screen shot is above

AbhilashR
14 - Magnetar
14 - Magnetar

@jjdenha - screenshot didnt come through. Can you upload it again?

jjdenha
5 - Atom

I did away with the 'and' and just used < for all of them problem solved

tonypreece
10 - Fireball

I was going to suggest just a simple less than each time instead of (greater than x and less than y).

 

The formula runs from left to right, so if the first test is matched, the formula can stop processing. This means if LoS is <=90 it stops at the first test, Alteryx doesn't go on to test if it is ALSO less than 180.

 

If it isn't <=90, but it happens to be <=180 that condition wins then the formula doesn't move any further, and so on until the first occurrence of a test being passed, or the final else if none are passed.