Skip to Content
1
Former Member
Jul 31, 2007 at 04:01 AM

Sub Total changing - Issue in BEx

13 Views

Hello Guys,

Here is my Issue.

I have BEx report that displays amount data by plant, year, month, day and Doc No.

I want Avg on all the above objects as sub total.

Say : I have 3 doc # in 1 day. so the sub total is sum (3 doc amount) / 3.

but when i remove the doc# and 0calday from the report that sub total by month is not displaying correctly. It is displaying the very first record amount instead of the monthly average of all docs in that month.

same for the year and plant.

could you please explain the issue.

thanks

pratap