Hi

I have one column which has 3 types of currencies. Euro, £ and $.

I want to total the 3 but if i do that it will be pretty useless as the total will not lead to any useful information. (due to the simple addition of the 3 currencies)

However is there a method of adding the 3 different euros and converting them at the same time to give me a total amount in £(pound).

So if there were any euro amounts to be added then they would be converted to £ and then summed up ( same being applied to the $ amounts)

Has anyone done this before? Help would be greatly appreciated