Forum Discussion

Melodyv's avatar
Melodyv
Icon for Helper I rankHelper I
4 years ago
Solved

Custom column summing multiple columns - some rows not summing?

I am trying to sum mutiple columns in the same table using a Custom Column.  This should be so simple, but some columns are summing correctly and others are returning a null value.  What am I doing w...
  • JorgePinho's avatar
    4 years ago

    The first thing to note is that a null value in a formula is not a zero. And a null value is not equal to a blank value.

     

    One solution is to replace null by 0 in each column using Replace Values.

     

    Another solution is to create the costum column with the function List.Sum this way:

    Short-Term Savings = List.Sum{(Checking Account(s), Savings Accounts(s), Cash)}

     
  • Melodyv's avatar
    4 years ago

    UPDATE!  I figured it out.  I just needed to replace the null values with 0.00 and now it works.  Leaving this here in case someone else has the same question.