# All Time Summation of Variables

Hello,

I have been searching around and have found a few examples of this being used for slightly different cases but nothing exactly like it. Forgive me if this is a simple solution that I am just missing…

But we want to simply add each incoming value for the same variable on top of the previous total. So if I feed the machine 5 lbs the first time and then feed it 7 lbs, I want a total of 12 to be displayed, and so on…Thus creating a widget called “total pounds digested” or similar.

Thanks!

Hi @psalibe,

You can achieve this cumulative summation using synthetic variables, specifically with the `cumsum(x)` function, which “Calculates the cumulative sum of the variable x”.
This how it look from the editor:

Makes sense?

2 Likes

Hello there,
I hope all is fine.Actually,my problem is also same to add all the values of a variable but,as i give zero value the sum variable must reset to zero and then ,start adding further values leaving all previous values.
Good day.

This is actually my requirement

Hello @psalibe

I was going through old posts and came across this one. There is one way you can achieve what you want and that is by using two synthetic variables as follows:

AUX

``````where(RAW==0,cumsum(RAW))
``````

CUMULATIVE

``````fill_missing(cumsum(RAW) - AUX)
``````

The `AUX` variable makes an accumulated every time the value of the `RAW` variable is zero, and the `CUMULATIVE` variable makes a subtraction between the `cumsum(RAW)` (that is always accumulating) and the `AUX` variable, to deliver the accumulated since the last time the value of the raw variable was zero. Makes sense?.

Below, you’ll find the logic of this solution.

I hope it works for you!

Have a good day,
Ángela