Yes the exchange rate is constantly changing but I can average it out. for each month. My problem is though the average becomes incorrect because when the invoice is in AUD the rate is 1. I need to somehow be able to average it out for the month and use this rate (but when working out this average exclude it when the rate is 1). I have not yet been able to achieve this with my grouping for each month (re multiple months).
In regards to the parameter, I would need multiple for each month and I dont know how many months or which the report will be run for as this will be different all the time. Also if they enter a rate for the Feb, Mar etc in the past they wouldnt want to continue to enter say 6 rates if looking at 6 months. The system would need to be able to at least store the old months parameters and maybe only enter a new month that has not yet been run before? Does any of this make sense...? I really need a solution!!! Ahhhh
IP Logged
