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

Count Days on Well but excluded specific Intervals by filtering


Dallas Dye 2

Recommended Posts

All, i have a general report number in my data set that is produced every day but it does not reflec the actual drilling days on the well. The interval labeling system is desinged to start once drilling starts and carry on throughout the well. What i want to do is have a starting point of day 0(first day) and start counting days from the first day after the last0 - pre Surface day. The formula i've been working with is below and the attached image shows the results along with the data layout.

 

Count([Well Name]) OVER (Intersect([Well Name],AllPrevious([Report No.])))-1

 

Thank you for your time,

 

Dallas

Link to comment
Share on other sites

  • 9 months later...

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...