AnsweredAssumed Answered

Adding Summary Fields

Question asked by hwerlin on Jan 8, 2010
Latest reply on Jan 8, 2010 by comment_1

Title

Adding Summary Fields

Post

<!--  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  -->

Outcomes