Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
4 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
Icon for Solution Sage rankSolution Sage
4 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
Icon for Post Prodigy rankPost Prodigy
4 years ago

Not helped, still see errors in that column.

  • AntonioM's avatar
    AntonioM
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi Analitika ,

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

    • Analitika's avatar
      Analitika
      Icon for Post Prodigy rankPost Prodigy
      4 years ago

      Here

       

       

      • AntonioM's avatar
        AntonioM
        Icon for Solution Sage rankSolution Sage
        4 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}})