You can create a summary field that gets the average of your calculated field.
Note that calculation and summary fields on a table that is an external SQL source, are IN FileMaker and not making any schema changes to the SQL table(s). Changing the contents of the SQL row/column is "Live" once the record is committed. Any such fields referenced by calculations or summaries, will update. But that data resides IN FileMaker and not SQL.
Sent from miPhone
Ah. I did. It understand that to be the case. That fixes my problem completely. Thank you so much!
2 of 2 people found this helpful
If you are not sure create tables that complement data in FileMaker for calculation and statistics per exemple.
For proper respect of fiscal regulation in France we must add crypted signatures and audit informations in accounting solutions. It was simple to do this adding complementatry tables that contains calculations for signatures without modifying tables. I made link between tables with ID of primary records.
If you want to be sure that your SQL datas will not change, you can consider your SQL database as an external database and create complementary tables inside an additional database or your solution database.
You split the risk