Adding Summary Fields
<!-- StartFragment -->
FM 10, Mac OS10.6.2
I am unable to add three Summary Fields together (all in the sametable) & then find the sales by location (location is located in another table).
I have tried the following & sorted by Salesmen::Location :
GetSummary ( TotalDSLR Units ; Salesmen::Location ) + GetSummary ( Total Video Units ; Salesmen::Location ) + GetSummary ( Total P_S Units ;Salesmen::Location )
This doesn’t work.
I feel I need self-join but have been unable to figure this out.<!-- EndFragment -->
The breakfield in GetSummary() cannot be a related field. Define a calculation field in the local (Sales?) table =
and use it for your sub-summary part, sort order and GetSummary().