I want to make some kind of recursive function for summing related records accordning to the values in an array.
My array looks like this:
Now i want FileMaker to sum all records in a related table where the record looks like this
I want o end up with something like this
Note there can be thousands of different values.
I can do this with script and a loop but i would like a custom function or somthing similar.