I’m finally working to move several of my File Maker databases to Panorama. I created one from a csv of raw data that captures up to 10 scores per an event (events are records with other fields such as date, location, etc.). I have four simple calculation fields on each record; the total number out of the 10 possible trials used (TotTrials calculated as count(TrialsΩ)), total scores in those trials (TotScores calculated as sum(TrialsΩ)), the average score across the trials calculated as (TotScores)/(TotTrials), and quantity calculated as TotScores*Load (a static numeric value).

When a new record is added with Load and Scores entered, only Total Scores (the sum of scores across the 10 available fields) and the quantity Total Scores * Load auto calculate. The other two require Morph/Recalculate Field to populate correctly. Obviously the calculations work (via morph), but I can’t determine why they don’t auto calc. Any help is appreciated.