Bex Report result Calculation (derived from other key figures result)

[Former Member]

Hi Expert,

   I have requirement in which I have to do calculation on result row in Bex Report. Result of one key figure should display the division result coming from other two key figure

Eg:

	Plant	Material	QTY	Unit Value	Value
L1	P001	1234556	4	550	2354234
	P002	1234556	6	345	2452
	P003	1234556	23	433	2452
	P004	1234556	56	165	545
	P005	1234556	2522	565	465
	P006	1234556	4565	455	546
Result			7176	328.971	2360694
L2	P009	1234556	500	700	500000
Result			500	1000	500000
Orverall			7676	372.68	2860694

As can see in the middle column (Unit Value)

L1

Result  328.971 = 2360694/7176

L2 

Result 1000  = 500000/500

Overall

Result     372.68 =2860694/7676

Like that value I need to display in bex report result row . format will be same. Extra column not needed.

I have tried many ways but I am unable to do.

Please some one help me out .... Or there some note .. regarding this,

Thanks in advance.

Regards,

Manoj Kumar

[former_member186053 · Accepted solution]

Hi Manoj,

Just an advice, give a try with SUMCT/SUMGT data functions. Create a formual for each KF with this data function, use it in a CKF/Formula to get final result.

Regards,

Vengal.

[Former Member · Accepted solution]

Hi Vengal,

Thanks for quick response,  To  use SUMCT/SUMGT  I have to create formula that will create an extra column in query out put. But user don't want this he want this calculation should be at result level. I must be displayed on result.

I want to revised my question.

Here ,

Value =  Qty * Unit value

And at the result  Unit value =  Value (result)/ Qty (Result)

Revised:

Plant	Material	QTY	Unit Value	Value
L1	P001	1234556	4	550	2200
	P002	1234556	6	345	2070
	P003	1234556	23	433	9959
	P004	1234556	56	165	9240
	P005	1234556	2522	565	1424930
	P006	1234556	4565	455	2077075
Result			7176	491.286789	3525474
L2	P009	1234556	500	700	350000
Result			500	700	350000
Orverall			7676	504.88197	3875474

L1

Result  491.286789 = 3525474/7176

L2

Result 700  = 350000/500

Overall

Result     504.88197 =3875474/7676

Is there Sap note that says that it is not possible at result row ?

Thanks and regards,

Manoj Kumar.

[Former Member · Accepted solution]

Hi Vengal and Naiduz ,

Thank you for your help.

I got the solution.

I used Leaf (x) function to do that.

(Leaf(QTY) == 1) * Unit Value + (Leaf(QTY) == 0) *(Value/ NODIM(QTY)) .

Regards,

Manoj Kumar.

[former_member186053 · Accepted solution]

Hi Manoj,

Good to hear that your issue is resolved and Thanks for posting the answer here.

Regards,

Vengal.

[former_member217770]

Use formula   result = value/QTY in  using bex formuals.