Adding a list of Multi Currencies
I Have a column in a list view that contains Currency values as strings i.e.
USD120.56
GBP200.00
HKD50.00
USD100.00
GBP50.00
How can I total these i.e.
USD220.56
GBP250.00
HKD50.00
My thought was to have an array or 2 arrays
CODE(X) and TOTAL(X)
CODE() will contain all possible currency codes the corresponding TOTAL() will contain the cumulative total for this currency code.
How it would work:
Now for each item in the list, search through the CODE(X) array from beginning to end until the matching currency code is located.
Once Located cumulate The TOTAL(X) by adding the value of the list item (ignoring the first 3 Characters of the string)
This will work but surely there must be a better more refined way to do this.
Re: Adding a list of Multi Currencies
It would be much easier if you were to load them in separate columns.
One column for current name and one for the actual number.