Calculation of result

[Former Member]

Hi expert's.

In Bex analyzer after executing the query (in excel sheet)

in the context menu we will get All characteristic---->

Normalize.

what is the purpose of it.

[Former Member · Accepted solution]

Hi Pradeep

It is to give you a percentage wise break up of the results of your query or output.

e.g.

cost Center Amount

1 400

2 1000

3 600

so when you normalise it will show in percentage terms

cost Center Amount

1 20

2 50

3 30

You can do it for the filtered restricted result on the screen or for the overall result of the query depending upon your requirement.

Cheers

Anurag

[Former Member · Accepted solution]

Hi Anurag thanx for quick reponse,

Can u plz explain in detail...

Plz

[Former Member · Accepted solution]

it is doing something like this, 400/2000 * 100 = 20;

1000/2000 * 100 = 50, 600/2000 * 100 = 30

where 2000 is the total amt. it is giving the % wise break-up

[Former Member · Accepted solution]

Hi,

To add to Ravi's explanation of the computation.

In the current normalisation the result what we are seeing is based on data what is actually on the screen when you execute the normalisation function.

But assume that there was one more record which had been filtered out as below

cost Center Amount

4 500

and if you normalize on the overall result instead of the result then the results would be

cost Center Amount

1 16 % (that is (400/2500)*100)

2 40 %

3 24 %

which would not total to 100 % as in the earlier post.

That would be the difference between Normalise on result and normalise on overall result.

hope it helps

Cheers

Anurag

[Former Member · Accepted solution]

Thanx Ravi and Anurag.