1 Reply Latest reply on Jan 8, 2010 5:55 AM by comment_1

    Adding Summary Fields

    hwerlin

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