Forum Discussion

zraopingm's avatar
zraopingm
Icon for Helper IV rankHelper IV
1 year ago
Solved

ADDED COLUMN DOES NOT CALCULATED CORRECTLY

Hello, this is in Power Query environment:

I have period 12 and 9, trying to see the difference by adding a cusomer column = 12-9

but not all rows are correctly calculated the difference.. not sure why?

thank you for your input

Zoey

 

 

 

Need Help

8 Replies

  • zraopingm's avatar
    zraopingm
    Icon for Helper IV rankHelper IV
    1 year ago

    lbendlin 

    thank you.. it seems only where the value is null, it does not work. that is why I replace null with 0

    thank you

    Zoey

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago

      Can you try to change your column names so they do not start with a number?

      • zraopingm's avatar
        zraopingm
        Icon for Helper IV rankHelper IV
        1 year ago

        thank you it does not work, but AlienSX suggested to use list.sum, it works. 

        Thank you for your time.

        Zoey

      • zraopingm's avatar
        zraopingm
        Icon for Helper IV rankHelper IV
        1 year ago

        thank you list.sum works! but why a straight forward col12-col9 does not work though? I will research on this further.

        thank you

        Zoey