Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
3 years ago

Can't divide zero

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 t...
Need Help
AntonioM's avatar
AntonioM
Solution Sage
3 years ago

Hi Analitika ,

 

You could try replacing the errors with null.

 

 

 

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

 

 

 

 

Analitika's avatar
Analitika
Post Prodigy
3 years ago

Not helped, still see errors in that column.

  • AntonioM's avatar
    AntonioM
    Solution Sage
    3 years ago

    Hi Analitika ,

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

    • Analitika's avatar
      Analitika
      Post Prodigy
      3 years ago

      Here

       

       

      • AntonioM's avatar
        AntonioM
        Solution Sage
        3 years ago

        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}})