Forum Discussion
Solved
Error IN FORMULA
Hi - I have a Total Employees column , however some rows doesnt have value and therefore the power query automatically shows null, now am trying to create a new custom column as Employee range with t...
sks2701 perhaps add an if statement (I would do it as the first) such that [#"Employees"] = null then "N/A"
Hi sks2701 ,
Besides check the null value at first, you can also replace errors with "N/A":
= Table.ReplaceErrorValues(#"Added Custom", {{"Custom", "N/A"}})Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sks2701 perhaps add an if statement (I would do it as the first) such that [#"Employees"] = null then "N/A"