Skip to Main Content

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!

Rounding for Percentages

DakkuOct 21 2013 — edited Oct 21 2013

Please advise someone. I have written the logic to calculate certain components in our application based on percentage. For example we take a percentage of Total Net Earnings. When I hard code the percentage in the logic the formula works to the precise number. So as step 2 i created a stat account where they can input the percentage in a specific account and then the calcualtion would be based of that account since our percentages change every month. When i did this the numbers are are off because the sstem does not see the percentage as the number I am entering but I beleive rounds it. The result is higher then what I want it to be. For example I entered 22.9 for the percentage. In the formula it used the exact amount but when I enter in HFM as a stat account it is not using it the way it is being entered. I assume it is rounding it but I don't want it to.

Can someone help how to tackle this issue

Thanks

Comments

Thanos A

Hi there,

Have you confirm that the NumDecimalPlaces of the stat account is not zero but it is more than 1? Only if you have a NumDecimalPlaces value, HFM will not round the number during the input.

Regards,

Thanos

One Truth about...: ...Apps 13, London

Dakku

Would this be in the metadata?

Thanos A

Hi again,

Yes, you should confirm that the stat account that you have created has as a NumDecimalPlaces attribute the value 1. Based on that you will be able to input data with one decimal.

Regards,

Thanos

One Truth about...: ...Apps 13, London

AmarnathK

Yes. You can have a look at the Account properties. Same place where you would see isCalculated, isConsolidated properties

Regards

Amarnath

http://amarnath-essbase-blog.blogspot.com

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 18 2013
Added on Oct 21 2013
4 comments
353 views