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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Just CHOOSE your columns from the box on the right. Choose, then write a minus sign, then choose again, and you're done.

 

--Nate

  • jusTodd's avatar
    jusTodd
    Icon for Advocate IV rankAdvocate IV
    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.