Formula applied to grouping?

[MBresnan]

This seems like it would be a simple process, but i'm hitting a wall. I have a dataset that has header level info, as well as detail, on each line. So for example: PO number, receipt number, amt ordered, amt received, price. Everything for a given PO number would be static, except Receipt number and amt received. I'm trying to create a report that will give a running total for all PO's, so i'm using the max amt ordered on a PO, and a sum of amt received. To get the amount remaining, i need to subtract those two summary fields. so i want to enter a formula in that group footer line. is that possible? or is there another way to do that?

 

[IanWaterman]

@Remaining

Maximum(AmtOrdered, PO)- sum(receivedAmt, PO)

Replace AmtOrdered, ReceivedAmt, PO with relevanet fields.

Ian

 

[MBresnan]

Perfect! Thanks!