9 Replies Latest reply on Nov 9, 2012 2:38 PM by philmodjunk

    Using GetSummary with a sort field that's not in the same table

    nickodm

      Title

      Using GetSummary with a sort field that's not in the same table

      Post

           So I have a report that needs to have some sub-summary fields. EVERYTHING calculates correctly EXCEPT when you run the report by Zip.

           So this works:

           If (GetSummary( SumCancel ; Type ) = 0 ; 0 ; GetSummary( SumCancel ; Type ) / GetSummary( SumSold ; Type ))

           But this does not work:

           If (GetSummary( SumCancel ; Leads::Zipcode ) = 0 ; 0 ; GetSummary( SumCancel ; Leads::Zipcode ) / GetSummary( SumSold ; Leads::Zipcode ))

           Any ideas? I am pulling my hair here.