Sum Multiple Fields CR XI 1

[Deb100]

I have 6 formulas in my Details section. I have a Summary on each formula in my Footer section.

I now need a Sum of 4 of the formulas and another Sum of the remaining 2 formulas. However, when I try to Insert a Summary I can only select one field to Summarise, not four.

Is there a formula I can use to add the 4 formulas together, or add the 4 Summary's together?

Eg.
@Formula1
@Formula2
@Formula3
@Formula4
@Formula5
@Formula6

Sum of @Formula1
Sum of @Formula2
Sum of @Formula3
Sum of @Formula4
Sum of 1+2+3+4
Sum of @Formula5
Sum of @Formula6
Sum of 5+6

 

[lbass]

Create formulas in the field explorer->new like:

sum({@formula1},{table.groupfield}) +
sum({@formula2},{table.groupfield}) +
sum({@formula3},{table.groupfield}) +
sum({@formula3},{table.groupfield})

Place these directly in the group footer.

-LB

 

[lbass]

The other approach would be to create a formula:

{@formula1}+{@formula2}+{@formula3}+{@formula4}

Place this in the detail section and insert a summary on it at the group level.

-LB