2 Replies Latest reply on Feb 10, 2016 6:32 PM by sccardais

    Problem calculating percent in sub summary reports

    sccardais

      I’m having trouble calculating an overall percentage in a sub-summary report.

       

      This is the calc I’m using: Overall_Percent = GetSummary(s_total_cancel, Cohort_Nbr) / GetSummary(s_Total_Orders, Cohort_Nbr)

       

      Cohort_Nbr is the break field.

       

      The Summary fields referenced in GetSummary are both calculating correctly in the Trailing Grand Summary part but the percentage formula isn’t.