Currency Conversion Rule

If your model requires a special currency conversion rule to handle the conversion of cumulative Profit & Loss accounts using an average exchange rate for the month, here’s how to set it up.

• Create a variable set called PLVars containing all the P&L type accounts that need to be converted.
• Add the following rule to the ActRules set

Name = CurrCalc

Range = [PLVars][input][YTD]

if(currview == @localcurrency, @input, 
if(time == @Jan, localcurrency:ytd / @CurCCR, 
(localcurrency:ytd - localcurrency:ytd:time[:>-1]) / @CurCCR + ytd:time[:>-1])) 

Make sure the rule is placed below any time or product calculations in the rule set.