Forum Discussion
Solved
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"]...
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
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.