Hi,I have a revenue table that keeps track of the revenue we receive for wells. We receive revenue about 3 months behind, so I want to create a summary total field on our wells table that totals the payment we receive for the most recent month.
So for example, our most recent revenue is from July. But if I make it "during the last 3 months" then the total will mess up when we get revenue for august and september.
Is there a formula or something that can work that out? or is there a way to filter it that I don't know about?
I like where this is going for a different issue I was going to ask about.
we need to track when we are missing consecutive payments, and I've been racking my brain on it.But, back to this issue - we do receive multiple payments for a well in a month, and different amounts too, and it could be from a different operator.
Operator 1 could give 3 different payments, while operator 2 gives one full payment, on the same well. (main operator and JV operator).
ok i'm going to give that a try.
I think I can do that for Main operator, and JV Operator.
(Operator is the oil company that drills the wells) - so Operator Payment checkbox and JV Operator checkbox. Right?