Hello, I have an app that has lessons graded in a portal row and I need to average the grade every 14 lessons. This way I can have a running average every semester. I need the average to start from scratch every 14 rows. Is this possible?
Have you looked at the FM Summary filed type options.
FileMaker Pro 16 Help
Total of: Running total
Count of: Running count
Might be helpful.
I assume your lessons are numbered and that there is some indicator that the lesson is complete. You could set a script to run when the number reaches 14, 28, etc. which would calculate an average at that point and store the result in a field for each result ("Avg at 14", "Avg at 28" etc). This also has the advantage of storing the result rather than having FMP do the calculation each time the layout opens.
Retrieving data ...