if Value.Is Zero Then?

[erikah06]

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?

[Zubair_Muhammad · Accepted solution]

@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"]

[erikah06]

Thank @Zubair_Muhammad this worked perfectly.