Hyperion Financial Management (HFM) (MOSC)

MOSC Banner

Rounding Calculations

edited Jan 15, 2014 12:13AM in Hyperion Financial Management (HFM) (MOSC) 4 commentsAnswered ✓
I have the following rule in HFM

     ElseIf sYear > "2013" Then 'Apply new rounding to VLH1100 only from 2014 onwards
      HS.round(1)
      Hs.Exp "A#BS111000T_R" & cNONE_c12I &" = A#BS111000T" & cTOP_c1234I
      Hs.Exp "A#CF900000T_R" & cNONE_c12I &" = A#CF900000T" & cTOP_c1234I
      HS.Exp "A#VLH1100" & cNONE_c1234I & "=A#BS111000T_R - A#CF900000T_R"
      HS.NoRound
     End If

However in the destiantion account CF900000T_R if the the source value (account CF900000R) has a value of same 543.49 it rounds up to 544 instead of down to 543.

The problem actually seems strangely intermitent. If you force the value down well below .49 (e.g. to say 543.10) then the rounding works correctly as you would expect. However, this is not consistent as it sometime remains correct when you move back to .49, and sometime does not. I have of course appliedForce Calculate several times.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center