Forum Discussion

zraopingm's avatar
zraopingm
Icon for Helper IV rankHelper IV
2 years 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...
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago

AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
2 years ago

zraopingm's avatar
zraopingm
Icon for Helper IV rankHelper IV
2 years 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

    • zraopingm's avatar
      zraopingm
      Icon for Helper IV rankHelper IV
      2 years ago

      that is a good read,

      thank you 

      Zoey