AnsweredAssumed Answered

Calculate related values from an array

Question asked by 5104619256 on Dec 22, 2015
Latest reply on Jan 4, 2016 by 5104619256

Im stucked

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:

1

5

7

9

 

Now i want FileMaker to sum all records in a related table where the record looks like this

5

5

9

5

 

I want o end up with something like this

5 3

9 1

 

But how?

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.

Outcomes