Can I underlay a group total?

[OT2]

Hi, I am using CR11 to create a report, client has asked for three groups: vendor, docnumber and account. All my data is at the account level, and I have a sum of amounts by account that I would like to underlay so that it appears in line with the last item in the account group, ie:

Vendor
DocNumber
Account Amount1
Account Amount2
Account Amount3
Account Amount4 Amount Total *Would like to appear here
------- -------
Total Amount Total **appears here on the report

Please let me know if this is possible, the underlay function hasnt worked for me, perhaps theres a formula I can use? Thanks,

 

[RobbieB]

Create these two formulas

//place this formula (@Formula_1) in the header of
//doc number

WhilePrintingRecords;
numbervar x;
x := 0

//place this formula on the account line (details?)
//(@Formula_2)


WhilePrintingRecords;
numbervar x;
x := x + {amount}

Then conditionally suppress Formula_2 like this:

if @Formula_2 = sum of {Amount_Total} then false else true

Leave the amount total where it is and suppress it

 

[OT2]

Hi Robbie, formulas work, but the total appears at the top of the account group, to the right of Amount1 in my example above, any way I can get it to jump to the bottom?

 

[OT2]

Robbie, I got this to work, please disregard my previous post. Thank you! Looks awsome.

 

[RobbieB]

Glad I could help.