Adding sums together

[auburnfan]

Hello all,
Is there a way to add two sums together? I have been trying to figure this out without much luck.
thanks

 

[lbass]

Do you mean two sums in the same group section or are you talking about totaling sums across different group instances?

-LB

 

[auburnfan]

Here is a breakdown of what I have.
{sumoftable.totalpages} this is say 100
{sumoftable.totaldeleted} this is say 50
I need it to tell me what the 100 - 50 would be.
They are in the same group not sure if that is what you mean though...

 

[lbass]

If these are in fact sums at the group level, then the formula would be:

sum({table.totalpages},{table.groupfield})-
sum({table.totaldeleted},{table.groupfield})

Place this in the group header or group footer.

-LB

 

[auburnfan]

That did it Thanks a bunch!