Skip to Content
0

Aggregated Values in Report

Oct 26, 2017 at 06:40 PM

25

avatar image
Former Member

Hi Experts,

I have a BEx query on top of infoset. A DSO is assigned to the infoset, what i want in the output is i need total gross margin based on sales order number, i tried with exception aggregation on sales order number it is giving me the values on line item wise which i don't need , i need the gross margin values at the total sales order number level.

Example:

Sales Order Number line item value Gross margin at sales order level

123 10 70 41.1%

123 20 100 58.8%

But it is displaying like below when i give exception aggregation.

Sales Order Number line item value Gross margin at sales order level

123 10 70 70

123 20 100 100

Any inputs are highly appreciated.

Thanks,

C.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Oct 27, 2017 at 09:08 AM
0

Hi,

could you try this

formula: % CT 'KeyFigure'

worked for me


uigfu.png (4.5 kB)
Share
10 |10000 characters needed characters left characters exceeded