Add if blank filter to calculated column

[Qotsa]

Hi,

Below calculated column returns "Early" if column [Visits_ActStart] is less than column [Visits_StartTime].

However, it also returns "Early" if [Visits_ActStart] is blank.

How can I modify this so it won't return "Early" if  [Visits_ActStart] is blank.

Punctuality = IF (vw_PivotOTIF[Visits_ActStart] < vw_PivotOTIF[Visits_StartTime]-1/24*.25,"Early",IF ([Visits_ActStart] > vw_PivotOTIF[Visits_StartTime]+1/24*.25,"Late","On Time"))

[yelsherif · Accepted solution]

You can use an extra condition for [Visits_ActStart] <> blank(), however, there is a better way to write down the column using SWITCH:

Punctuality = SWITCH(TRUE,

vw_PivotOTIF[Visits_ActStart]=blank(),"undefined / No show",

vw_PivotOTIF[Visits_ActStart]< vw_PivotOTIF[Visits_StartTime]-1/24*.25,"Early",

vw_PivotOTIF[Visits_ActStart]= vw_PivotOTIF[Visits_StartTime]-1/24*.25,"On time",

vw_PivotOTIF[Visits_ActStart]> vw_PivotOTIF[Visits_StartTime]-1/24*.25, "Late"

)

[Qotsa]

That does exactly what I need. Thank you. I will look to use SWITCH in future.