Can't divide zero

Question

Hi,&nbsp;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 · Answer

Hi&nbsp;Analitika&nbsp;,
&nbsp;
You could try replacing the errors with null.
&nbsp;

&nbsp;

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

&nbsp;
&nbsp;
&nbsp;

analitika · Answer

Not helped, still see errors in that column.

antoniom · Answer

Hi&nbsp;Analitika&nbsp;,
Please can you post a screenshot of the column and the errors?

analitika · Answer

Here&nbsp;&nbsp;

antoniom · Answer

Strange, you should be able to replace the errors in the column, do you have a step that looks something like this?
&nbsp;
#"Replaced Errors" = Table.ReplaceErrorValues(#"Changed Type", {{"h/val", null}})
&nbsp;

Forum Discussion

Can't divide zero

5 Replies

Related content

Divide in Power BI

Divide columns

divide function

Divide two columns

Divide formula in power query