Skip to Content
0
Former Member
Mar 28, 2007 at 04:06 AM

Subtotal different from overall result

19 Views

Hello BW Experts,

Requirement.

Report shows this info

Sales ord, sale item, sales amt, sales item amt ,

1001, 1, 500,250

1001, 2, 500,250

Result 500, 500

1002, 1, 600, 300

1002, 2, 600, 300

Result 600, 600

Overall result 1100, 1100

How to model the sales order amount so that it shows 500 in the result and also 100 in the overall result.

Are these solutions?

Does the any exception aggregations help

Does creating the sales order amt as the attribute of sales order > formula var > ckf help ?

Any other possible solutions for this problem, please suggest.

Regards,

BWer