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 1||Coin 2|
|Years||Coin 1||Coin 2||Total|
|1||1/10 (= decimal value)||1/10|
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)