Hi Expert,
First and foremost, thanks for reading my question..
I am new to HFM, and need some assistance with a writing rule to allocate difference between End-of-Period (EOMRate) and Average (AVGRate) rates to the Foreign Currency Translation Account (FCTR):
Rule Requirements:
1. Look at all base entities that are non-AUD (Parent entity is denominated in AUD)
2. Work out difference between EOMRate and AVGRate rates
3. Multiply difference with the Profit After Tax account (ie PAT)
4. This amount to be reported in the FCTR account (ie 9115)
Rule that I have written, which HFM does not like:
If HS.Entity.IsBase("","") = True And HS.Value.Member <> "AUD" Then
HS.Exp "A#9115 = A#PAT * Difference("AVGRate", "EOMRate")
End If
The AVGRate and EOMRate rates I am looking at are in C2. Have given this rule quite a number of attempts but with no luck. Would appreciate input from you experts out in the HFM world..
Thanking you in advance.
Jeff