Invelos Forums->DVD Profiler: Desktop Feature Requests |
Page:
1  Previous Next
|
|
Total Purchase Price |
|
|
|
|
|
| Author |
Message |
| Registered: March 13, 2007 | | Posts: 76 |
| | Posted: | | | | How do I find the total purchase price of my collection (the sum of all of my discs) I used to keep an excel spread ship to calculate this, but i stopped updating it about a year and a half ago...and now with my explosion into hd, I would have to go back and add a couple hundred discs, which I don't feel like doing.
I've tried the database query plug in, but it leaves the purchase price and msrp totals blank. I've ran a query to see if any of the prices are missing and I've filled in all of the missing data. so I don't know why the fields are blank.
Is there a way of getting the totals in dvdprofiler itself? |
| | Registered: March 13, 2007 | Reputation:  |  Posts: 1,946 |
| | Posted: | | | | Tools --> Charts & Graphs
Bottom section has Price Paid, both total and average.
The only problem with this is, it doesn't make a difference in currency. The first 2 years I paid in Belgian Francs, valued about 1/40 of 1 Euro, making 2000 and 2001 ranking highest in what I've paid, even though I purchased much less DVD's then. | | | View my collection at http://www.chriskepolis.be/home/dvd.htm
Chris |
| | Registered: March 13, 2007 | Reputation:  |  Posts: 2,217 |
| | Posted: | | | | Quoting mistermoravec: Quote:
How do I find the total purchase price of my collection (the sum of all of my discs) If I need a warning about my buying habits I'll run a certain report. Go the the Reports Download and search for "discount", that will bring up DVD Discount Report (v 1.0) and download it. Brace for impact befor running it.  cya, Mithi | | | | Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki |
| | Registered: May 27, 2007 |  Posts: 691 |
| | Posted: | | | | [deleted] | | | | Unfortunately, I can't use DVDprofiler at the moment due to lack of a Windows computer. | | | | Last edited: by EdwinK |
| | Registered: March 13, 2007 |  Posts: 21,610 |
| | Posted: | | | | Quoting Mithi: Quote:
Quoting mistermoravec:
Quote:
How do I find the total purchase price of my collection (the sum of all of my discs)
If I need a warning about my buying habits I'll run a certain report.
Go the the Reports Download and search for "discount", that will bring up DVD Discount Report (v 1.0) and download it.
Brace for impact befor running it.
cya, Mithi Battle stations. Skip  | | | ASSUME NOTHING!!!!!!
CBE, MBE, MoA and proud of it.
Outta here
Billy Video |
| | Registered: March 13, 2007 | | Posts: 76 |
| | Posted: | | | | wheewww...Less than 20 grand...I'm not crazy
thanks for the information... I dl'd the discount report | | | | Last edited: by mistermoravec |
| | Registered: March 13, 2007 | | Posts: 21,610 |
| | Posted: | | | | Quoting mistermoravec: Quote:
wheewww...Less than 20 grand...I'm not crazy
thanks for the information... I dl'd the discount report LOL, that is no indication of your being crazy or not, it is indicative that you are not utterly insane. Skip | | | ASSUME NOTHING!!!!!!
CBE, MBE, MoA and proud of it.
Outta here
Billy Video |
| | Registered: December 13, 2008 | | Reputation: | | Posts: 334 |
| | Posted: | | | | Quoting mistermoravec: Quote:
I've tried the database query plug in, but it leaves the purchase price and msrp totals blank. I've ran a query to see if any of the prices are missing and I've filled in all of the missing data. so I don't know why the fields are blank. With the database query it defaults to "hide financial data". Click the last icon (Options) and UNcheck the first box : Hide financial data on summary tab. Restart DVDprofiler and you'll have your financial data! Big advantage of using the plugin is that you can differentiate between currencies. Kudos to Mark Harrison for making this great tool for us.  Cheers, Steve |
|
|
|
Invelos Forums->DVD Profiler: Desktop Feature Requests |
Page:
1 Previous Next
|
|
|