New to FMP - Question on Calculations between Similar Records
I'm very new to FMP and have tried to search for an answer and probably overlooking it.
I have 3 tables.
Customer ---< Tanks ----< Production History
I'm using portals to display Production History on Tanks and Tanks on Leases ... that is good.
What I'm trying to figure out is how to calculate differences between 2 records in the Production History.
Production History has daily gauges:
Gauge Date, Gauge Foot, Gauge Inches, Gauge Quarter Inches, Total Inches (calculation field to show total inches)
What I would like to do is calculate daily production based on the previous record for that specific tank. (and if it goes beyond 1 day, calculate the days between the dates and divide the production by that amount.)
1/4/2014 - 4'0"0, 48 * 24 inches in 2 days and 12 per day.
1/2/2014 - 2'0"0, 24 ** 12 inches between the two dates.
1/1/2014 - 1'0"0, 12
Thanks in advance!