4 Replies Latest reply on Jan 5, 2010 12:13 PM by therin

    Calculating the percentage of all records in a layout

    therin

      Title

      Calculating the percentage of all records in a layout

      Post

      I have a layout page that displays the number of items in a specific category based on a field, like this:

       

      Electronics   60

      Food           34

      Drinks          23

      Other          10

       

      Total           127

       

      Is there any way i can display a percentage of the total, such as 47.24% for Electronics? I have already tried using a calculation field for this, Filemaker displayed the same value for each category when I did and I could not figure out how to get the total without entering it manually into the calculation.

       

      Im using Filemaker Pro 10 on Windows Xp. Any help would be great, thanks