AnsweredAssumed Answered

Generating quota/year from range of years

Question asked by u.stock on Oct 17, 2018
Latest reply on Oct 22, 2018 by eric

Hi there,

 

I wonder if there is a way to automatically determine the quota/number from a range of numbers (almost certainly, but I can't figure it out - luckily, there are smarter brains out there, perhaps you?). As this might sound enigmatic or just gibberish, I'll try to illustrate it with my example:

The fields "Year_start" and "Year_end" contain numeric values describing the date range of archaeological objects (coins). The goal is to automatically process the data in order to get a table showing the quota (=probability of manufacturing) per year for all the data sets, e.g.

 

Coin 1Coin 2
Year_start18
Year_end1015

YearsCoin 1Coin 2Total
11/10 (= decimal value)1/10
21/101/10
31/101/10
41/101/10
51/101/10
61/101/10
71/101/10
81/101/81/10+1/8
91/101/81/10+1/8
101/101/81/10+1/8
111/81/8
121/81/8
131/81/8
141/81/8
151/81/8


Adding the values for each year to get the total, and the basic mathematical formula to obtain the quota/year "=1/(Year_start - Year_start+1)" are clear to me. However, I am struggling with the work in-between...

Thank you very much for your help!

 

------

FileMaker 12 Pro (Windows)

Outcomes