AnsweredAssumed Answered

Problem totaling results of GetSummary in Sub Summary Report

Question asked by sccardais on Sep 5, 2015
Latest reply on Sep 5, 2015 by sccardais

I want to total the values in the far right column - Net New Clients - in this sub summary report.

 

c_NetNewClient is a calc field with the calculation shown below.

 

GetSummary(s_TotalNbrOrders;Edition) - GetSummary(s_TotalNbrCancellations;Edition)

 

I am sorting on Edition and the results in the sub summary part are correct. But I have not been able to total their results in the Trailing Grand Summary part. The field, s_NetNewClients (summary, total of c_NetNewClient) does not work.

Total calc using GetSummary function.png

What am I doing wrong here?

Outcomes