E9.1 Auto Aggregate On A LB Footer Section

[FrankCLT]

For the life of me I can’t remember the process of getting the totals per level break footer. I do recall that once placed on the footer and you hover over the fields, the associated fields in the main section would turn red.

Thanks in advance,
FrankCLT

 

[JohnDanter2]

Click into your level break footer setion

top menu > Section > Add Aggregates

Pop up appears

Click left Operator column

Total of > right Operand then shows a list of the math type fields. So you'd have to make a note of the names of the fields you want to total

 

[FrankCLT]

That is exactly what I've done but the popup shows nothing.....

 

[JohnDanter2]

Ok confused then

Maybe goto data sequencing of your main Work File section. Define Sort Properties tab, is your Payment terms ticked as a level break?

Failing that, check in, check out try again

 

[FrankCLT]

Done all that, doing the totals manually until I can figure it out.... Weird though....

Thanks for your replies....

FrankCLT

 

[JohnDanter2]

Welcome
I've been playing around with onw of my well known UBEs and I can't break it like you no matter what I do. Change the LVL BK field, change sequence, untick things. All still works

I even made my LVL BK conditional like you (not sure why you've done that) and I could still see them.
If there's not to much code, humour me and recreate another LVL BK section and see

 

[FrankCLT]

I will experiment a little more.......

 

[craig_welton]

https://support.oracle.com/epmos/faces/DocumentDisplay?id=1524831.1

Been fighting this for a while. Looks like it's fixed in new TR

Craig

 

[FrankCLT]

Oh.......good to know, manual totaling it is.

Thank you,