### Title

calculation problem: dividing 2 summary fields in a sub-summary layout part

### Post

Okay I have to summary fieds that I want to divide to get a percentage. They are sitting in the subsummary part of my layout, that is in list view. The summary fields alone work in the sub-summary part but when I make a field to divide the one by the other and place it into the sub-summary part. It gives me the same number down the entire page in every sub-summary. This is the calculation I am using.

sum_udbe_amount_achieved / sum_bid_amount

Thanks

Yep, when you use summary fields in a calculation, they evaluate just as though they were not in the sub summary part. They return a "grand total" based on your entire found set. To use the sub totals as displayed in your sub summary part in your calculation, you have to use the GetSummary function.

GetSummary ( sum_udbe_amount_achieved ; BreakField ) / GetSummary ( sum_bid_amount ; BreakField )

Where BreakField is the "when sorted by" field designated in your sub summary part.