Can't divide zero

[Analitika]

Hi,

I have question how to divide one column values from other. One column contains quantity other column sum. I need sum divide quantity but some quantity column values are 0. So what to do in this case because now I am getting an error?

[AntonioM]

Hi @Analitika ,

You could try replacing the errors with null.

Now you'll have blanks where you were dividing by 0.

[Analitika]

Not helped, still see errors in that column.

[AntonioM]

Hi @Analitika ,

Please can you post a screenshot of the column and the errors?

[Analitika]

Here

[AntonioM]

Strange, you should be able to replace the errors in the column, do you have a step that looks something like this?

#"Replaced Errors" = Table.ReplaceErrorValues(#"Changed Type", {{"h/val", null}})