Generalised currency conversion
I'm building a model which holds revenue data. The revenue that the company receives is in a mix of US Dollars, UK Sterling and Euros, so one of my lists represents currency. There is a requirement as well to aggregate that revenue into a single "Converted Sterling" currency, which would be calculated as (Revenue in UKP) + (Revenue in USD * USD Exchange Rate) + (Revenue in EUR * EUR Exchange Rate).
I've also got a fair number of Line Items that I want to apply such a currency conversion to, some of which have their own formulae.
I really only want to write the currency conversion formula once; I don't want it included in each of the Line Items that it applies to.
How do I do that in Anaplan?
Thanks in advance.