Hello, So I'm working on a formula where the dates where Null and I cleansed it to blanks but need a specific output if the days are empty. I currently have below but it is malformed. Any suggestions? IF ToNumber([Days Between]) 30 Then 'Reseach' Elseif IsEmpty([Days Between]) Then 'N/A' Else 'Research' ENDIF I Used this to get my 'Days Between' If that's needed. DateTimeDiff([Appraisal_Sent_To_Applicant_Date],[Appraisal_Received_Date],'Days') Thanks in advance for your time.

IF Isempty([DaysBetween]) THEN 'N/A' ELSEIF ToNumber([DaysBetween]) 30 check as it has the same output as the else

If field is blank error

Hello,

So I'm working on a formula where the dates where Null and I cleansed it to blanks but need a specific output if the days are empty. I currently have below but it is malformed. Any suggestions?

IF ToNumber([Days Between])<=30 Then 'Pass'
Elseif ([Days Between])>30 Then 'Reseach'
Elseif IsEmpty([Days Between]) Then 'N/A'
Else 'Research' ENDIF

I Used this to get my 'Days Between' If that's needed.

DateTimeDiff([Appraisal_Sent_To_Applicant_Date],[Appraisal_Received_Date],'Days')

Thanks in advance for your time.

Error Message

Accepted answers

Carlithian

IF
Isempty([DaysBetween])
THEN
'N/A'
ELSEIF
ToNumber([DaysBetween]) <= 30
THEN
'Pass'
ELSE
'Research'
ENDIF

Changing the order has fixed it on my end, I guess empty is less than 30, but if we check for that first it will mark it as N/A
This was also removes the need for the >30 check as it has the same output as the else

All comments

Carlithian

In the first part of your statement you use ToNumber on Days Between, but you dont do this for the second part. I believe this will be your issue.

Either use the ToNumber function again, or put speech marks around the 30 and treat it as text 😊

Also in the formula where you have created the Days between, you will be able to select if you want the output to be treated as a string or an int etc. So perhaps setting it to int there will be your better option, and drop the ToNumber function all together

Happy Alteryxing

CRogers22

Thank you that corrected the formula but its still showing blanks as Pass. how do I handle Empty cells?

Deano478

Howdy @CRogers22 feel free to give this a go and let me know what happens:

IF ToNumber([Days Between]) <= 30 THEN 'Pass'
ELSEIF ToNumber([Days Between]) > 30 THEN 'Research'
ELSEIF IsEmpty([Days Between]) THEN 'N/A'
ELSE 'Research' ENDIF

CRogers22

Days Between	Automated Results
	Pass
	Pass
	Pass
	Pass
	Pass
	Pass
	Pass
	Pass
	Pass

Still returning Pass for blank cells

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335