...using ProfilerQuery. If you are lucky enough to have found every DVD you wanted in your own country, and thus only have prices in one currency, this is really easy. Use no selection. Put SRP Value or Purchace Price Amount (or both) in the presentation. Run the query. Select File-> Save and Run in the menu in order to open the result in your spreadsheet application. Use the Sum function to calculate the total. However, if you have prices in several different currencies, things get a little more difficult. Not much, though. Best not to do both SRP and Purchase Price at the same time. So let's say we do SRP. Add SRP Value and SRP Currency to the presentation. Run the query. Sort the result on currency by clicking the header. Transfer the result to your spreadsheet. For each currency, use Sum to total the prices for that currency. Use your favorite online currency converter to convert that sum into your own currency. Then finally sum up these into one grand total. And most important of all! Don't show your significant other how much you have spent on your hobby! |