Count Days on Well but excluded specific Intervals by filtering

[Dallas Dye 2]

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

[Khushboo Rabadia]

Can you please provide a sample dxp showing the expected output value for Days on Well. Currently based on the custom expression, it will just count all the rows prior to current row for any well.

[Dallas Dye 2]

I was able to work with a buddy and below is the formula he came up with to solve my issue,

 

(If([interval]"Specific Interval",Rank([Report No.],"asc",[Well Name - G]))) - 1

 

Sorry for the dalay,