Calculations in a Leading Sub-Summary

[CatLady03]

:help: In simple terms, I want to create a calculation field that divides the count in the Leading Sub-Summary part by a total count found in a Leading Grand Summary part to display as a percentage in the Leading Sub-Summary part. Here's what I have.

• gtempCount as a global field
  
• Symbol Count as a Summary field in the Leading Grand Summary part
  
• Symbol Count as a Summary field in the Leading Sub-Summary part
  
• Symbols text field in the Body part (actual field that is counted)
  

This seems simple enough, but I just can't seem to make it work. Sometimes I think I think too much and can't see the forest for the trees.

Can someone please point me in the right direction?

Thanks so much!!

[Søren Dyhr]

This must be very close to this:

http://www.filemakerpros.com/PERCENT2.zip

--sd

[CatLady03]

:thankyou: I appreciate the sample database. It was very helpful. I still have a problem, though.

In my database, the found set is coming from the main table and the breakfield is coming from the Sector table. The defined relationship between the two is Symbol.

In my report layout, I have a total symbol count in the Grand Summary part (R2K Count defined in the main table), which represents the total number of companies in the found set. Then in the Sub-Summary by Sector part (which also contains the breakfield, Sector), I'm using the same R2K Count field, which represents the total number of companies within each sector. These two fields display accurately in Preview mode.

My problem is with the R2K Percent field, which is also defined in the main table...I can't get it to display in Preview mode. This is what the calculation looks like for the R2K Percent field:

[color:blue]GetSummary ( R2K Count; Sector::Sector)/R2K Count

I have checked to ensure that it is within the boundaries of the part. Nothing displays. I know the field is there because I gave it a bottom border and the border displays fine.

In your sample database, you have two separate count fields and you use two Sub-Summary parts. I have one Grand Summary part and one Sub-Summary part. I'm counting the same field in two different parts, so I'm not sure if your sample shows the same thing that I'm doing or not. I'm confused by the differences.

I think I'm close, but I still have a blind spot. Sometimes the nuances of this stuff can be stifling.

Any help will be appreciated...thanks!!

[Søren Dyhr]

which is also defined in the main table...

This is a faulty approach, it should only be present in one tabel, to get it displayed in another tables layout requires you bolster the solution with sufficient table occurances!

If your breaker value is related won't GetSummary work, the field needs to be stored or a summary field:

http://network.datatude.net/viewtopic.php?t=128

--sd

[CatLady03]

My apologies. I wasn't clear in what I wrote. The words you quoted mean that this field is located in the same table as the other field, not that it existed in two tables. I'm sorry I wasn't clear.

Let's see if I can be really clear about the field locations.

Main Table:

• R2K Count (Summary Field)
  
• R2K Percent (Calculation Field)
  
• Report Layout
  

The Sector table only contains the Sector field, which is also the breakfield for the layout.

Does this help...I hope??

Thanks again for your input.

[Søren Dyhr]

Wow I just modified my previous post!

--sd