Forum Discussion

RichardJ's avatar
RichardJ
Responsive Resident
6 years ago
Solved

SWITCH assuming a blank numeric column is zero - need help with syntax

Apologies for the rookie question but I cant figure out the correct syntax to generate values in a new column. I think the issue I am having is due to the switch function identifying a Blank numeric...
Need Help
  • az38's avatar
    az38
    6 years ago

    RichardJ 

    maybe this

    Forecast Accuracy =
SWITCH(
TRUE(),
ISBLANK(DrawingSet[Duration between Forecast and Approval]), "No Data",
DrawingSet[Duration between Forecast and Approval] >0, "Delivered Early",
DrawingSet[Duration between Forecast and Approval] =0, "Delivered On Time",
DrawingSet[Duration between Forecast and Approval] <0, "Delivered Late",
"Undefined"
)
az38's avatar
az38
Community Champion
6 years ago

RichardJ 

maybe this

Forecast Accuracy =
SWITCH(
TRUE(),
ISBLANK(DrawingSet[Duration between Forecast and Approval]), "No Data",
DrawingSet[Duration between Forecast and Approval] >0, "Delivered Early",
DrawingSet[Duration between Forecast and Approval] =0, "Delivered On Time",
DrawingSet[Duration between Forecast and Approval] <0, "Delivered Late",
"Undefined"
)
  • RichardJ's avatar
    RichardJ
    Responsive Resident
    6 years ago

    Thanks for making my day @az38. That worked perfectly - I wouldn't have worked out that approach.