Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Daily value from cumulative number

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.

 

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      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?