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

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?