Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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:

SALES2016.0183.333,0000000-
SALES2016.0283.333,0000000-
SALES2016.0383.333,0000000-
SALES2016.Q1INP250.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,

Former Member
replied

After you decide and implement your rounding strategy then you can create script to compare sum of disaggregated amounts with total and put the difference somewhere...

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question