1 person found this helpful
Here is a helpful link, which describes floating point calculates in HFM. Also, check to see what you have set as the maximum number of decimal places in your account.
Thank you very much for your reply. I click the link and to access the document and it ask me to provide Support Identifiers. I may have to ask the admin in my company for that.
I used HFM Metadata manager to check my account properties. The only related field I see is
NumDecimalPlaces = 2
It applies to all the members in my account dimension.
Here is the article:
Accuracy of HFM in Floating Point Calculations (Doc ID 1437033.1)
HFM calculations are carried out with 15 significant decimal digits; this includes the digits to the left and right of the the decimal point. The round-off error noted is considered normal for floating point calculations. In fact, the relative error is 1.29 x 10^-15.
There are multiple sources for round-off errors in floating point calculations, including conversions between decimal and binary (used internally to store numbers), internal calculations such as aggregation, consolidation, etc, and storage and retrieval in the database. The order of calculations can also affect the visibility of round-off errors.
That is 15 significant decimal digits is the maximum accuracy can expect with the product.
- HS.Round() functions can be used to narrow down numbers especially in dynamic account rules