AnsweredAssumed Answered

Problem calculating percent in sub summary reports

Question asked by sccardais on Feb 10, 2016
Latest reply on Feb 10, 2016 by 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.

Outcomes