Thank you for your post.
In a calculation field, the GetSummary () function has two parts; the summary field, and the break field. For the current sub-summary, you may have something like:
GetSummary (ValueSummary; ParentProduct)
That is, grab the value from the ValueSummary field and break it down by the ParentProduct component field.
If you use the summary field also for the "break field"...
GetSummary (ValueSummary; ValueSummary)
... you will have the total for the entire found set of records. Therefore, the calculation:
GetSummary (ValueSummary; ParentProduct) / GetSummary (ValueSummary; ValueSummary)
... returns the percentage for each sub-summary section.
Does this help?
Apologies for late reply, trying to in and out of Thailand!
Your suggestions worked of course and thanks.
Although I had tried 'GetSummary' what I hadn't understood was that it had to be in the same table! I am using four and just randomly created the calculation in the current table I was editing at the time. Wrong!!