AnsweredAssumed Answered

Adding Summary Fields

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


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