Forum Discussion
if Value.Is Zero Then?
I am using the formula in m language calculated column "=if Value.Is([#"MDBF Years.2018 - YEAR 1"],0)then [#"MDBFMileage.MDBF Mileage Year 1 - 2018"] else ([#"MDBFMileage.MDBF Mileage Year 1 - 2018"]/[#"MDBF Years.2018 - YEAR 1"])"
The goal is to identify fields with the number zero, I attempted to replace "0" with null and still return an "ERROR"
Does anyone have any guidance on this formula?
erikah06
Try the normal if statement=if
[#"MDBF Years.2018 - YEAR 1"]=0
then
[#"MDBFMileage.MDBF Mileage Year 1 - 2018"]
else
[#"MDBFMileage.MDBF Mileage Year 1 - 2018"]/[#"MDBF Years.2018 - YEAR 1"]
2 Replies
erikah06
Try the normal if statement=if
[#"MDBF Years.2018 - YEAR 1"]=0
then
[#"MDBFMileage.MDBF Mileage Year 1 - 2018"]
else
[#"MDBFMileage.MDBF Mileage Year 1 - 2018"]/[#"MDBF Years.2018 - YEAR 1"]Thank Zubair_Muhammad this worked perfectly.
