Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to calculate the difference for Sales, Year= 2015, using the xrate for that period and the Sales for the same period using the xrate for 2016.
Any ideas, how to?
Thanks.
Can you explain bit more, Please? I am assuming, you may need this?
Sum({<Year = {'2015'}, period = {'xrate'}>}Sales)
Sum({<Year = {'2016'}, period = {'xrate'}>}Sales)
Hi,
xRates Cal.? you mean exchange rate calculate for two different year?
If Yes, try like bloew John solution.
Thanks,
Deva
Hi all,
Let me elaborate a bit more:
This is to be applied in a table with Last Year Sales as first column and YTD Sales in the last.
The idea is to have also the calculation for (Last Year Sales/ Exchange Rate for Last Year) - (Last Year Sales/ Exchange Rate YTD ) included on this table.
I also use a standard currency conversion script to have all exchange rates.
Thanks for the replies.