Forum Discussion

jusTodd's avatar
jusTodd
Icon for Advocate IV rankAdvocate IV
3 years ago
Solved

Simple Subtraction Problem

Attempting to do the death-defying performance of simple subtraction between two columns in Power Query is not giving me the expected results.   Still a freshman to whi world, can someone help me u...
Need Help
  • jusTodd's avatar
    jusTodd
    3 years ago

    That is exactly what I did!

     

    Thank you for reminding me of the silliest thing.

     

       480-null = null

     

    I needed to replace null with 0 first.

     

    Now it works.

JamieW135's avatar
JamieW135
Frequent Visitor
3 years ago

Thanks, this really helped me, I forgot that null actually existed in the cell and could be replaced!  So simple.,..