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...
Need Help
  • JorgePinho's avatar
    JorgePinho
    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
    Melodyv
    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.

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