I'm trying to do a command but I can't work out how to get it to recognise 0 as a number rather than a blank, the issue I have is I have both blanks and 0's in my column, this is my command:
Solved! Go to Solution.
In the first clause , remove the '= BLANK()' and put isblank before the column name (with brackets round the column)
Use ISBLANK(column) rather than '= BLANK'
Sorry how do I work that into my command I already have? Thank you
In the first clause , remove the '= BLANK()' and put isblank before the column name (with brackets round the column)
Perfect thank you for your help 😊
.. by the way, although the code works, nested IFs like that are a nasty way to accomplish it. SWITCH is a much more readable way to go - like this:
Day Groups = SWITCH(
TRUE(),
ISBLANK( 'Claims Full + Complaints'[Days from Claim to Complaint] ), "No Complaint",
'Claims Full + Complaints'[Days from Claim to Complaint] = 0, "Within 15 days",
'Claims Full + Complaints'[Days from Claim to Complaint] < 16, "Within 15 days",
'Claims Full + Complaints'[Days from Claim to Complaint] < 31, "Within 30 days",
'Claims Full + Complaints'[Days from Claim to Complaint] < 61, "Within 60 days",
"Over 60 days"
)