Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set up the number of decimal place in HFM calculation?

892733Aug 23 2013 — edited Aug 23 2013

Dear All:

My HFM 11.1.2.2 does some strange thing in calculation.

I have some account/entity POV with

<Entity Currency> = 1000.00000000000000

<Entity Curr adjs> = - 1000.00000000000000

When HFM added them up

<Entity Curr Total> =0.00000000046566

It really distorted my calculation in the next step since some number will divide by <Entity Curr Total>

I wonder how to set up the number of decimals in HFM. May I just have 6 -8 digits after the decimal.

or

is there any way to have my

<Entity Curr Total> =0.00000000000000

Thank you so much for your feedback.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 20 2013
Added on Aug 23 2013
#business-intelligence-applications, #financial-consolidation, #hfm, #in, #of, #performance-management-applications, #to
3 comments
1,466 views