compute sum depending on column value

[LECOMTE FRANCOISE 2]

I have 2colums : one for timestamp column Date-Time DD/MM/YYYY hh:mm:ss and one column Equipment which contains only 0 or 1

I create a Intervalle column to calculate the interval of time between 2 rows :Minutes(DateDiff([Date-Time],first([Date-Time]) over (previous([id_ligne]))))

I would like to compute cumulative amount of minutes where my column contains 1

Date-Time Equipment Interval Cumul I can do Cumul I Want

01/01/2020 05:00 1

01/01/2020 05:10 1 10 10 10

01/01/2020 05:11 0 1 11

01/01/2020 05:20 0 9 20

01/01/2020 05:25 0 5 25

01/01/2020 05:30 1 5 30 15

01/01/2020 05:35 1 5 35 20

01/01/2020 05:40 1 5 40 25

01/01/2020 05:45 1 5 45 30

 

 

 

Do you have any idea to do that

[Gaia Paolini]

try this:

If([Equipment]=1,sum([interval]) over (AllPrevious([Date-Time])),NULL)