Hello to all the HFM users out there,
I am having some trouble with my currency translation calculation. To explain this, let's say I have 2 additional exchange rates (AVGRATE1 and AVGRATE2) that I want to use for my cash flow accounts besides the default EOM and AVG rates that are stored in my HFM application. I understand that HFM's translation rule is cumulative in nature and here's what I have in my translation subroutine.
HS.Trans "C2#CFCALC" , "C2#CFCALC", "A#AVGRATE1", ""
HS.Trans "A#CF_XXX.C2#CFCALC" , "A#CF_XXX.C2#CFCALC", "A#AVGRATE2", ""
As you can tell, I want all the accounts to be translated using the AVGRATE1 except for CF_XXX accounts. What I am seeing is that it is doing the translation twice and I end up getting twice the amount in the <PARENT CUURENCY> of A#CF_XXX.
I know I can add some IF ELSE statements to handle this but I is there a cleaner way to do this? I have done some research and looked around but can;t find a cleaner solution.
Thanks in advance!
CCH