Cumulate the values ​​of the same column daily

AppSheet AppSheet Q&A
,
1

Hello

I’m getting back to you because a new problem is causing me concern.

A little reminder:
I record my electricity consumption daily. As a former Excel user, I created a lot of intermediate calculation columns and I was advised to use virtual columns to lighten the Google Sheet.

My problem:
First, I want to accumulate daily consumption. How can I accumulate today’s values ​​with the cumulative values ​​from the previous day?

I created a virtual column: ConsoJour and I wrote the following formula:
If(the entry corresponds to the first line of the table then I cumulate the different readings otherwise, I cumulate the different readings of the day with the cumulation of the day before)

Which gives me the following formula:
If([_RowNumber]=2,
[Conso Bleu HP]+[Conso Bleu HC]+[Conso Blanc HP]+[Conso Blanc HC]+[Conso Rouge HP]+[Conso Rouge HC],
[Conso Bleu HP]+[Conso Bleu HC]+[Conso Blanc HP]+[Conso Blanc HC]+[Conso Rouge HP]+[Conso Rouge HC] + LOOKUP(
MAXROW(“Releve quotidien”, “_ROWNUMBER”, ([Le] < [Le])),
“Releve quotidien”,
“ConsoJour”,“ConsoJour”)
)

The formula is validated by the appSheet.
When I save, the data refresh is blocked.

I hope that my speech has helped you understand my problem. Thank you for your always valuable help.

Have a nice day everyone

2

When I save, the data refresh is blocked.

What does this mean? Is an error displayed? If so, please post a screenshot of it.

3

Hi there, I found a great video demonstrating an OCR electric meter reader app built using AppSheet. I think it could provide some valuable insights and inspiration for your project.

Here’s the link: https://youtu.be/CwqR72AQNBQ

1 Like
4

Hello,

@aijac1314 :I will watch the video carefully to see if I can adapt it to my case. Thank you very much for your help

@Steve : I attach the image of the error that is returned by the application during synchronization. Thank you for your help

ErreurConsoJour.jpg
ErreurConsoJour.jpg288×536 20.3 KB

1 Like
5

This is wrong:

Steve_0-1730472521636.png
Steve_0-1730472521636.png436×109 4.37 KB

What is the Le column for?

6

[Le] is the title of the column contains the date of the day

[ConsoJour] is the column countains the sum of the differents counters used each day

1 Like
7

I actually think you might be better off doing what you want to do in the spreadsheet instead. Running-totals are difficult to do in AppSheet.

1 Like
8

Thank you very much for your advice

Jeannot45

1 Like