How do you do a Grand Total on Totals of Maximum Values?

[Wenin]

I am trying to create a report that examines the maximum values of a field within Group #2, then displays that Max Value
I then want to create a Total of the Max Values under Group #1


I'm able to do the first part, I've been unable to find a way to total the max values.

[jggtz]

Try formula fields

[Wenin]

I created three formula fields with the following properties.


WhilePrintingRecords;
numberVar nMaxInt1:=0;
numberVar nMaxInt2:=0;
numberVar nMaxInt3:=0;
numberVar nMaxInt4:=0;
numberVar nMaxInt5:=0;
numberVar nTotal1:=0;
numberVar nTotal2:=0;
numberVar nTotal3:=0;
numberVar nTotal4:=0;
numberVar nTotal5:=0;



WhilePrintingRecords;
numberVar nMaxInt1;
numberVar nMaxInt2;
numberVar nMaxInt3;
numberVar nMaxInt4;
numberVar nMaxInt5;


if {SampleData.UC_MARC_Commodity_CUM_QTY_1} > nMaxInt1 then nMaxInt1 := {SampleData.UC_MARC_Commodity_CUM_QTY_1};
if {SampleData.UC_MARC_Commodity_CUM_QTY_2} > nMaxInt2 then nMaxInt2 := {SampleData.UC_MARC_Commodity_CUM_QTY_2};
if {SampleData.UC_MARC_Commodity_CUM_QTY_3} > nMaxInt3 then nMaxInt3 := {SampleData.UC_MARC_Commodity_CUM_QTY_3};
if {SampleData.UC_MARC_Commodity_CUM_QTY_4} > nMaxInt4 then nMaxInt4 := {SampleData.UC_MARC_Commodity_CUM_QTY_4};
if {SampleData.UC_MARC_Commodity_CUM_QTY_5} > nMaxInt5 then nMaxInt5 := {SampleData.UC_MARC_Commodity_CUM_QTY_5};



WhilePrintingRecords;
numberVar nMaxInt1;
numberVar nMaxInt2;
numberVar nMaxInt3;
numberVar nMaxInt4;
numberVar nMaxInt5;
numberVar nTotal1;
numberVar nTotal2;
numberVar nTotal3;
numberVar nTotal4;
numberVar nTotal5;


nTotal1 := nTotal1 + nMaxInt1;
nTotal2 := nTotal2 + nMaxInt2;
nTotal3 := nTotal3 + nMaxInt3;
nTotal4 := nTotal4 + nMaxInt4;
nTotal5 := nTotal5 + nMaxInt5;



Then placed these fields at the points that I wanted to collect the data.