Discussions

Expand all | Collapse all

CALCULATE BASED ON A STATUS

  • 1.  CALCULATE BASED ON A STATUS

    Posted 04-07-2021 17:00

    Hi,

    We have Units in Wells and we need to calculate the average lateral length of the unit based on how many wells are in the unit, and what their lateral length is, but only for a certain status of well.

    So some wells are producing, some wells are being drilled. We can only calculate the producing wells.

    For instance in this screen shot we have 3 wells in the unit, but only 1 of them is Producing (BM STATUS IS PDP).  So technically the average is the lat length of that one PDP well. (or if there were 2 PDP, etc).

    This is the current formula - I put the first part thinking that would work - but it only SHOWS the average on the PDP well, not calculate if it is a pdp well.
    If([BM STATUS]="PDP",[UNIT - TOTAL LAT LENGTH]/[NUMBER OF WELLS IN UNIT-SUMM])

    Any ideas is greatly appreciated!



    ------------------------------
    Renee Hansen
    ------------------------------


  • 2.  RE: CALCULATE BASED ON A STATUS

    Posted 04-07-2021 18:29
    no problem, you seem to already have a summary field which calculates the average lateral length .

    Adjust that summary field to add the condition to only summarize the wells where the [BM Status] is PDP 


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------