What is a good way to implement scaling and rounding in HFM?
Recently we implemented HFM 11.2.14 for a customer. They are loading full amounts and are looking for a way to scale the numbers in millions and retain only two decimal places. If anyone has tackled these changes please share your insight.
- We are considering using an alternate scenario, scale in millions followed with Hs.Round(0.01). We though about doing the calculation at the base accounts but then this result in difference for example at all the balance sheet face level accounts.
- We don't want any reconsolidation and recalculation so we were thinking of doing the calculation at base as well as parent entities. How would the calculation happen at all different value dimension members?