Constant value for a key figure based in a characteristic.

[Former Member]

Experts.

I have a value attached to a characteristic which it should be a constant (GDP) .

Doc 1 <> mkt <> GDP <> SALES

1 <> 003 <> 1200 <> 100

2 1 <> 003 <> 1200 <> 300

33 <> 003 <> 1200 <> 150

45 <> 003 <> 1200 <> 150

If I am interested in the total of market 003 this is 700 and GDP column should show 1200

If I want to find out as percentage of GDP I should have 700 /1200

Right now what I get for market 003 is 700 and 4800.

Actually for each line item I will have 1200 and right now documents show the addition of the gdp according to the number of line items.

Please how can I make this constant….. thank you.

[Former Member]

VJ

I have tried that and not success..

My customer wants to normalized their analysis based on the Gross Domestic Product (GDP). It has clients that are like brokers they are re-sellers across the country. In order to analyze the performance, and since is not expected to have the same sales for client is nebraska or new York ( the GDP is bigger in NY).

They can do several analysis of sales by product line, broker, salesman, etc by just dividing the total by the corresponding regional GDP. However, my key figure with the GDP gets added over and over. How do I make it constant.

Thank you.

[Former Member]

Hi

One way would be Virtual KF - but thats in efficient way and can cause performance issues.

--S@A..

[Former Member]

Vjay.

thank you for your answer. I have tried to do what you suggest but didn't get the result could you please explain on detailed.

thank you.

[Former Member]

In the properties of Keyfigure GDP, Calculate Result as --> use Max or Min as applicable.

VJ

[Former Member]

Can you explain with a example what are you looking to achieve?

--S@A

[Former Member]

What I understood is that GDP should not be summed up.

If so, change the definintion of GDP to Exception Aggregation --> Maximum or Minimum etc as applicable.

Regards

VJ

[Former Member]

hi..

I have tried several things.. could you please be more explicit.. how would you do it?

Thank you.

[Former Member]

Alfonso,

Try using new formula and build the logic. I am not much clear from you inputs but I believe this can be achieved usingnew formulas in the query itself.