A calculation on a summary field
I have a db which is basically a Bill of Materials.
I total the value of the components (a summary) used in each parent product which is placed in the leading summary part (contaning the parent part number) of the report and is sorted by the parent part number. What I need to do is perform a percentage calculation on the value of the components and place that field in the same summary part. The result though is repeated in every summary which is the percentage calculation of the value of all the components in all the BOM's
My brain hurts!