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
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
354 views