AnsweredAssumed Answered

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

Question asked by nickodm on Nov 9, 2012
Latest reply on Nov 9, 2012 by philmodjunk

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.

      

Outcomes