5 Replies Latest reply on Jun 6, 2013 7:42 PM by 991139

# # of Decimals in a Calculated HFM number - Won't go out to 4 digits!!!

Help! I am trying to calculate an account in HFM and have it go out 4 digits. Aggrevating, it's only calculating out 2 decimal places!!! I've already set the calculated account's metadata property to 4 decimal places....My calculation is VERY simple. What am I doing wrong...

Sub Metrics()

Tops = ".I#[ICP Top].C1#TOTC1.C2#TOTC2.C3#TOTC3.C4#TOTC4"

If HS.Entity.Member = "SR001" Then

HS.Exp "A#BASIC_EPS_YTD = A#NetIncome.W#YTD" & Tops & " / A#BASIC_SHRS_YTD"

End If

End Sub
• ###### 1. Re: # of Decimals in a Calculated HFM number - Won't go out to 4 digits!!!
One thought might be that if you are viewing the data from a data form, check the decimal place settings under form details.

That might help.
• ###### 2. Re: # of Decimals in a Calculated HFM number - Won't go out to 4 digits!!!
I am viewing the data in Smartview & the data grids. Either way only calcs out to 2 digits.... I.E. The result is .1300 where it should be .1313 (as when I calculated the components by hand).
• ###### 3. Re: # of Decimals in a Calculated HFM number - Won't go out to 4 digits!!!
Try utilizing this Round/NoRound function in your rules:

HS.NoRound Function (turns off rounding for the account)
HS.Exp "A#BASIC_EPS_YTDNoRound" = " A#BASIC_EPS_YTD "

Or:

HS.Round Function 0.0001 (rounds to the ten thousandths)
HS.Exp " A#BASIC_EPS_YTDRound " = " A#BASIC_EPS_YTD "
• ###### 4. Re: # of Decimals in a Calculated HFM number - Won't go out to 4 digits!!!
Ok. This solution appears to force me to create an additional member in the metadata? Outside of the ones I already have? Correct?
• ###### 5. Re: # of Decimals in a Calculated HFM number - Won't go out to 4 digits!!!
Thanks for leading me down the right path. After you post, I scanned the rules file and found the very obvious HS Round function in already in place & responsible for rounding everything to 2 decimals! Thanks for your help.