How to use HS.CalculateRate
Hello everyone,
I'm stuck on something, possibly someone can help me.
I want to do a calculation where for each base entity the corresponding FX rate should be used as multiplier. This is how the code looks like:
If HS.Entity.IsBase("", "") = "True" and HS.Value.Member = "<Entity Currency>" Then
FXEnt=HS.Entity.Member
FXRate = HS.CalculateRate ("S#ACT", "Y#CUR", "P#CUR", FxEnt, "V#<Entity Currency>", "A#EOMRate")
HS.Exp "A#Target= A#Source*1500*" & FXRate &""
End If
I am getting error message. "(" missing. What am I doing wrong? Does Hs.CalculateRate expect other input variables?
Thanks a lot in advance!