6 Replies Latest reply on Sep 15, 2010 12:27 PM by Lorette

    Report Question: Minimum and Maximum Reporting Issue

    Lorette

      Title

      Report Question: Minimum and Maximum Reporting Issue

      Post

      Hi Everyone,

      I am having a problem getting the  minimum and maximum per structure type. I have tried everything, please help.  Thanks.

      The following did not work:

      sumHours: Summary Field =Total of Hours

      StructureTotal: Calculation Field = GetSummary (sumHours;StructureID)

      StructureTypeMinimum: Calculation Field =Min (StructureTotal)

      -----------------------------

      Example:

      Structure Type,    Structure ID, Hours

      K, 1, 8

      K, 1, 10

      K, 2, 20

      K, 2, 30

      V, 3, 15

      V, 3, 20

      V, 4, 55

      V, 5, 50

      -----------------------------

      Expected Result:

      K     Minimum 18, Maximum 50

      V     Minimum 35, Maximum 55

      -----------------------------

      Please refer to my notes below for an additonal question. Thanks.

      ----------------------------------------------------------------------------------------------------------------------------------

      Part 2:

      Thanks for your quick response.  I am very new to filemaker and appreciate any help you can provide. Unfortunately, I still need some additional assistance.

      I need to determine the minimum,maximum & average total hours per structure for each category. Below I will explain the logic of what I need to do.....

      Step 1:  Add up all the hours per structure ID

      K - 1 = 18 hours

      K - 2 = 50 hours

      V - 3 = 35 hours

      V - 4 = 55 hours

      V - 5 = 50 hours

      Step 2: For each structure type (e.g. K & V), determine the minimum, maximum and average...

      K: Min = 18 (structure 1), Max = 50 (structure 2) , Average = 34 [(18 + 50) / 2]

      V:Min = 35, Max = 55, Average = (35 + 55 + 50) / 3 = 46.67

      Any suggestions? Thanks!

      ----------------------------------------------------------------------------------------------------------------------------------