Former Member

### Decimal points for DP key figures

Hi guys,

Is there any way we can store up to 5 decimal point data in the planning book keyfigures?

We want to store "exchange rate" which has 5 decimal points, but our infoobject with data type "number" can store only 3 decimal points.

We are on 4.1

Anha

10|10000 characters needed characters exceeded

Feb 09, 2009 at 03:25 PM

Dear Anha,

Note 389760 states that Live Cache cannot store more than 3 decimal places.

But you can calculate and display the values in the planning book with a specified number of decimal places varying between 0 and 6.

e.g. if you are trying to store a material price value as 0.00050 in the LiveCache that is not possible. It will always be stored as 0.

But if this value is calculated using a macro (or otherwise), then it can be displayed as 0.00050.

Regards,

Tibor

10|10000 characters needed characters exceeded
• Former Member

That was a good peice of information Tibor.

In that case, Anhya..what you can do is..you can write a macro of KF1 = KF1 /100 and store 5 digit at planning area and display level.

• Former Member
Feb 09, 2009 at 09:33 AM

You can set the decimal points for a keyfigure at the planning area level (the way the data is to eb stored in LC).

And then you can also set the decimal points to be displyed by right clicking on the keyfigure in the design mode.

10|10000 characters needed characters exceeded
• Former Member Former Member

I dont think so..Can you try setting it at planning area level? I dont have a system at hand to test this

• Former Member
Feb 10, 2009 at 05:43 AM

>In that case, Anhya..what you can do is..you can write a macro

>of KF1 = KF1 /100 and store 5 digit at planning area and display level.

That is what we are thinking now, since there is no other way, I'll do in this way.

Thanks guys,

Anha

10|10000 characters needed characters exceeded
• Former Member Former Member

As per my understanding, the decimal places @ plannig area level is the most important as that is how the data is going to be available in LC. So even if it is 4 decimal places at UOM level, it will be displayed with 3 decimal places.