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 h...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

Anonymous 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    This worked, thank you very much Ryan!

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      5 years ago

      you are welcome