Skip to Content
avatar image
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

Thank in advance,

Anha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    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.

    I hope I could help you further.

    Regards,

    Tibor

    Add comment
    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.

      This should help you solve ur problem

  • avatar image
    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.

    Please let me know if you need any more information

    Add comment
    10|10000 characters needed characters exceeded

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

    Thank you Tibor, Anuradha

    >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

    Add comment
    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.