Hi, A sales person has targets & sales in three countries with their own currencies.
The sales persons achievement in each country can easily be calculated ...Sales/Target as a %.
But to work out the total achievement must the targets and sales all be converted to one currency?
Or as shown in the picture can the currencies be ignored and the target and sales columns be added up to give the total 90.56%
Thanks for the assistance
The sales persons achievement in each country can easily be calculated ...Sales/Target as a %.
But to work out the total achievement must the targets and sales all be converted to one currency?
Or as shown in the picture can the currencies be ignored and the target and sales columns be added up to give the total 90.56%
Thanks for the assistance