HFM Rules : How to pull fx rate present in a different Scenario?
Dear Experts,
I have a requirement where in I will have to pull AVGRate present in Budget scenario and use this rate to translate accounts with Actual as pov scenario. I have tried using HS.Getcell and HS.GetRate but both of the functions are not giving the output that is expected.
AVGBUD_Rate = ""
AVGBUD_Rate = HS.GetCell ("A#AVGRate.E#[None].I#[ICP None].V#[None].Department#"& ENT_CURR &".BusinessStream#USD.Product#[None].RFActivity#[None].SourceType#[None].S#Budget")
Above line is not pulling AvgRate present in Budget Scenario. Its pulling AvgRate present in Actual Scenario.
AVGBUD_Rate = HS.GetRate ("S#Budget.E#[None].V#[None].Department#"& ENT_CURR &".BusinessStream#USD.Product#[None].RFActivity#[None].SourceType#[None].A#AVGRate")