Daily value from cumulative number

[levialae]

Hi

I am trying to calculate the daily consumption of energy. The number I have is a cumulative value, so I need to subtract the value at end of day with beginning of day. However, I am not sure how to do this - can you please help me with this.

[ryan_mayu]

@levialae 

pls check if the attachment helps.

[levialae]

Hi Ryan

I think it worked but only partly. I have attached a new screenshot - it seems it only works on the first row, and I am not sure why that is.

Do you know why that might be?

[ryan_mayu · Accepted solution]

@levialae 

I  used some of your data in the screenshot. pls see the attachment.

[levialae]

This worked, thank you very much Ryan!

[ryan_mayu]

you are welcome