AnsweredAssumed Answered

Report Question: Minimum and Maximum Reporting Issue

Question asked by Lorette on Sep 14, 2010
Latest reply on Sep 15, 2010 by 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!

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

Outcomes