rounding of BPC data when saving (number of places after decimal point)

[Former Member]

Dear experts,

I have a question related to roudning of signed data. BPC saves data up to 7 places after the decimal point. Is there a BPC 10.0 NW parameter that could be changed or set in order to save data up to 9 places after the decimal point? Is there any solution to this and is it technically possible?

Thank you kindly for the answers,

Ralitsa

[former_member186338 · Accepted solution]

7 places after decimal point is a limit!

By default it's 13 integer and 7 decimal, can be increased to 24 integer and 7 decimal...

Read note http://service.sap.com/sap/support/notes/1829297

Vadim

[Former Member · Accepted solution]

Thank you for the reply!

[former_member186338 · Accepted solution]

But what for you need 9 decimals???

[Former Member · Accepted solution]

the users do some complex calculations to find % values which are saved to the database. For an example we have value of 0.181794572 that has to be saved, but in reality 0.1817945 will be in the database. Then when data are refreshed in the report they will see 18.18% (18.17946) and when they use this value to calculate another amount for comparison reasons, they sometimes get small deviations due to the rounding which in terms cause them problems when data are retracted to ERP and they have to do postings......

[former_member186338 · Accepted solution]

Ups, you are talking about Excel formulas and saving the results! Then you have to properly use ROUND Excel function. With proper Excel rounding you will not have any deviations. We use input templates with ROUND for years...

Vadim

[Former Member · Accepted solution]

We do use the ROUND....... it is a very complex sheet .... i have given them another solution let' see....

thank you very much for the suggestions and help