Jump to content
We've recently updated our Privacy Statement, available here. ×

compute sum depending on column value


LECOMTE FRANCOISE 2

Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...