1 Reply Latest reply on Dec 18, 2014 3:22 PM by philmodjunk

    Average Grade not populating

    annguest

      Title

      Average Grade not populating

      Post

      Hi,

      I'm new to Filemaker and using Pro Adv. I have a layout with a number of portals containing information on a person. I'd like to calculate the Average Grade for that person based on the information shown in the portal. I can't get my script to work. It's returning an error - the operation could not be completed because this layout cannot display the result.

      I've also attached a copy of the script in case I've done something wrong.

      Any help appreciated.

      TIA

      avggradescript.png

        • 1. Re: Average Grade not populating
          philmodjunk

          Go To Related records is intended to pull up a found set for a related set of records. These are usually, (unless you have a "self join" linking two occurrences of the same table), different tables so the current layout is probably not based on the same data source table as "Staff_tbl_TeacherEvaluationForm". And you wouldn't want to do that any way if you are going to use the Average aggregate function to compute the average. This calculation should evaluate from the context of the Parent record--the current record of the layout where you have a portal to Staff_tbl_TeacherEvaluationForm. If you tried to use it with this syntax on a layout based on the Staff_tbl_TeacherEvaluationForm, you would just get the value of Grade for the current record.

          I suggest looking up this function in FileMaker Help or any training materials you might have to learn more about how aggregate functions work.