cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Rounding values function in calculated KF SAP IBP

Former Member
0 Likes
3,432

Hi Experts

Currently I'm working with a custom Key Figure but I need to express the result as an integer value (no decimals)

Do anybody knows the function and syntaxis in the function builder in IBP?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

piyush_parekh
Active Contributor
0 Likes

Hi,

You can use ROUND function as follows:

KF1@PERPRODLOC = ROUND(KF@ PERPRODLOC, 0)

This will remove the decimals from the source key figure. To display the key figure without any decimals in analytics, change the Decimal Places in Display Settings. The default setting is 6 decimal places. Refer model configuration guide for more details.

Hope this helps!

Regards,
Piyush

Answers (0)