Skip to Content
avatar image
Former Member

Bpc rounding

Hi,

I developed a script logic for divide the values by 3 for testing

for example

*XDIM_MEMBERSET CATEGORY = Forecast

*WHEN TIME

*IS 2016.Q1INP

*REC(EXPRESSION = ([ACCOUNT].[SALES] / 3), ACCOUNT = SALES, TIME = 2016.01)

*REC(EXPRESSION = ([ACCOUNT].[SALES] / 3), ACCOUNT = SALES, TIME = 2016.02)

*REC(EXPRESSION = ([ACCOUNT].[SALES] / 3), ACCOUNT = SALES, TIME = 2016.03)

*ENDWHEN

The result in BW table is:

SALES 2016.01 83.333,0000000- SALES 2016.02 83.333,0000000- SALES 2016.03 83.333,0000000- SALES 2016.Q1INP 250.000,0000000- 499.999,0000000-

Is there any trick so it last period for example make it correct?

Or I'm not applying the Best practices, if not please let me know what can be.

Thanks.

Regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 22, 2015 at 09:23 AM

    There is no way to put rounding errors in some particular member! BPC stores data with 7 digits after decimal point, in reality you will have:

    x.3333333 😊

    First you have to think about result rounding in general!

    We use write back badi for this purpose and account dimension property - ROUND - to specify number of decimals...

    Vadim

    Add comment
    10|10000 characters needed characters exceeded