Is it possible to have the statistical model created without decimal points?
In Excel, I can change the 'view' but it doesn't change the underlying data - which includes decimal points. I need the stat to be created without decimal points.
Or is this something I would want to utilize a Copy Operator and Copy the stat model creation to another KF and have the Copy Operator round up/down the forecast?
Ended up utilizing the 'Round' calculation in the KF calculation. Just had to make sure it was utilizing the Round calculation at the correct level and after all the other calculations are completed.
Thanks for sharing your findings Dan.
Can you please throw some light on the "Round" Calculation operator.
Have you tried "Ceil(KF value)" ?
Can you the please share the snapshot of your Key figure calculation Expression :)
That would really help
https://blogs.sap.com/2016/02/17/sap-ibp-working-your-way-with-decimals/
check this article, if it gives a diff persepctive
Try configuring the "Display Settings" in the Model Configuration: Key Figures
Below are the standard Key Figure display properties with 6 decimals
Try changing the decimals to '0' and share if it works
Regards
VenKat
That only changes the display in the WebUI, it doesn't change it in Excel nor does it change the underlying data.
In Excel, I have done the EPM formatting and it shows the formatting correctly at first glance. But when you select the KF cell the data including decimal point is still there.
It does make me curious because I would expect a forecast to be created in 'eachs' or base UOM. No reason to have a decimal point when you can't manufacture it that way. ie - I can make either 15 or 16 pieces, not 15.68343