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!

HFM Rules - Dynamic account and rounding

207285Sep 17 2008 — edited Sep 17 2008

Is there a way to round what is stored in a Dynamic account in the rules file? For example:

HS.Dynamic "A#AvgRevPerDth.W#YTD = A#RegGasTransportRev.W#YTD / A#S_Dth_YTD"
HS.Dynamic "A#AvgRevPerDth.W#Periodic = A#RegGasTransportRev.W#Periodic / A#S_Dth_MTD"

I need the AvgRegPerDth to be stored as a value rounded to 2 decimal positions. It doesn't look like I can use HS.Round in the Dynamic rule.

My problem is that on a report, my Actual amount is .4357, displayed as .44. My Budget amount is .4224, displayed as .42. When the variance is calculated based on the stored values, it calcs a value of .01 and appears wrong because of the displayed values. If I could round the values stored in the dynamic account, it would show properly.

Any help would be greatly appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 15 2008

Added on Sep 17 2008

#business-intelligence-applications, #dynamic, #financial-consolidation, #hfm, #performance-management-applications

2 comments

1,118 views