AnsweredAssumed Answered

Trailing Grand Summary Problem

Question asked by sccardais on Oct 29, 2014
Latest reply on Oct 29, 2014 by sccardais

Title

Trailing Grand Summary Problem

Post

My sub summary report is based on a table "ORGs" that is related to itself using two match fields: Price Tier and Status.

The report shows the count of records in a related table using a calculated field - "c_CountOrgsByPriceTier"

The calculation for this field is Count(ORGs_self_tier::c_PriceTier) This calculation correctly displays the number of related records.(e.g 22 in Tier 0, 100 in Tier 1, etc.)

I want to sum these values in a Trailing Grand Summary. I have a summary field that totals c_CountOrgsByPriceTier. I place this in a Trailing Grand Summary but the results are incorrect.

I've looked at this every way I can think of but cannot understand why the total is not working.

What might I be doing wrong?

The attached screenshot shows how the relationship is defined and the structure of the Layout.

 

Screenshot_of_FileMaker_Pro_Advanced_%2810-29-14%2C_8%3A20%3A49_AM%29.png

Outcomes