Hello All,
I am trying to do a currency conversion for the Singapore admin entity whose local currency is 'SGD' and this has to be translated to 'USD'. I have exchange rates as average rate, closing rate, custom rate, historic rate1 and historic rate 2. When I am trying to translate it's not working properly. Help Appreciated!!
I think my output should produce something like
increases1000
decreases 1000
movement 3000
Sub Translate()
HS.Trans "C4#Increases","","A#HistoricRate1",""
HS.Trans "C4#Movement","C4#Increases","A#HistoricRate2","A#CustomRate"
HS.Trans "C4#Movement","","A#ClosingRate",""
HS.Trans "C4#Decreases","","A#AverageRate",""
End Sub
These are my input values for the following which are not 'is calculated' members
increases100
decreases200
movement300
My currency rates (input)
Average rate10
closing rate 20
custom rate 30
historic rate1 40
historic rate 2 50
My output values are
(after doing translate)
Increases is 4000
Decreases is 4000
Movement is 5000
Closing balance is 5000