Re: CALCULATE BASED ON A STATUS

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