| Author |
Message |
| Registered: March 2, 2014 | | Posts: 31 |
| | Posted: | | | | In the statictics/graphs I can see how much I've spend each year.
1.
Is there a way I can just see the overall total, so I don't have to manually add the total of each year?
2.
Also with average price, can I choose an overall average, instead of manually calculating it?
Thanks |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 3,321 |
| | Posted: | | | | The Database Query plugin will help you there. There might be another plug-in floating around that might help too. The name is escaping me at the moment, but perhaps someone else will recall. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. | | | | Last edited: by Mark Harrison |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | ProfilerQuery is the other tool I'd suggest. I'm not sure if it does this or not, but it's worth checking. If not, talk to Gunnar. He's very responsive to adding features. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|
| Registered: March 2, 2014 | | Posts: 31 |
| | Posted: | | | | Cheers! :-)  |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 2,217 |
| | Posted: | | | | Quoting Allanlegarthnielsen: Quote:
Cheers! :-) Before you use either plugin I suggest to have a phone at hand in case of heart failure  Also make sure that a spouse or significant other isn't in the room to see those numbers. | | | | Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki |
|
| Registered: March 13, 2007 | Reputation:  | | Posts: 17,334 |
| | Posted: | | | | Oh I so don't want to know! | | | | Pete |
|
| Registered: March 2, 2014 | | Posts: 31 |
| | Posted: | | | | HAHAHA   I will keep that in mind  | | | | Last edited: by Allanlegarthnielsen |
|
| Registered: March 26, 2009 | | Posts: 1,387 |
| | Posted: | | | | You can go to reports and use the insurance report it will give you the total purchase price and retail price of your whole collection. |
|
| Registered: March 2, 2014 | | Posts: 31 |
| | Posted: | | | | Quoting OldMan56: Quote:
You can go to reports and use the insurance report it will give you the total purchase price and retail price of your whole collection. Great idea! Cheers |
|
| Registered: March 14, 2007 | | Reputation: |  Posts: 4,678 |
| | Posted: | | | | Quoting Mark Harrison: Quote:
ProfilerQuery is the other tool I'd suggest. I'm not sure if it does this or not, but it's worth checking. If not, talk to Gunnar. He's very responsive to adding features. Just FYI, ProfilerQuery does not do this. The main reason is that there are potentially multiple currencies involved and calculating a unified value would require exchange rates, which makes it complicated. However, ProfilerQuery does provide you with an ability to gather lots of other information about your collection, and it's well worth your time to give it a try. Check it out here. | | | My freeware tools for DVD Profiler users.
Gunnar |
|
| Registered: March 14, 2007 | | Posts: 5,734 |
| | Posted: | | | | Quoting Allanlegarthnielsen: Quote:
In the statictics/graphs I can see how much I've spend each year. "Group: None" looks interesting.  | | | | Don't confuse while the film is playing with when the film is played. [Ken Cole, DVD Profiler Architect] |
|
| Registered: March 2, 2014 | | Posts: 31 |
| |
| Registered: March 2, 2014 | | Posts: 31 |
| | Posted: | | | | For those interested, I've now spend £11658,99 the last 15 years collecting films! :-) But I still need to plug in a few prices  |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 4,678 |
| |
| Registered: August 22, 2013 | | Posts: 2 |
| | Posted: | | | | Well after I ran the "insurance report" I went to my Homeowners insurance company and added my collection to my policy. My collection vastly exceeded the standard amount for loss of media. Food for thought.  |
|