Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculating Consumption from day before

Hi,  I have a data set gathering readings from various meters per mintue in a table called historian, the readings are accumlated, i am trying to get the daily consumption by getting the difference ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    I have managed to find a work around whenever the meter gets reset, by having an If condition and adding the maximum reading number to the last value and subtracting the next day reading. 

     

    Thanks 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I have managed to find a work around whenever the meter gets reset, by having an If condition and adding the maximum reading number to the last value and subtracting the next day reading. 

 

Thanks 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous,

Thanks for your sharing.😊

I think this workaround will be helpful if others faced a similar scenario.

Regards,

Xiaoxin Sheng