ADDED COLUMN DOES NOT CALCULATED CORRECTLY

[zraopingm]

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

[zraopingm]

@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

[AlienSx · Accepted solution]

[zraopingm]

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

[AlienSx]

read this

[zraopingm]

that is a good read,

thank you 

Zoey

[lbendlin]

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

[zraopingm]

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

Thank you for your time.

Zoey

[lbendlin]

Show the code for "Added Custom"