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...
Need Help
  • AlienSx's avatar
    AlienSx
    1 year ago

AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
1 year ago

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

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

      that is a good read,

      thank you 

      Zoey