# Report for avg amount saved by using the library
**URL:** https://forum.innovativeusers.org/t/report-for-avg-amount-saved-by-using-the-library/1929
**Category:** Polaris
**Created:** [July 11, 2024, 1:24pm UTC](https://forum.innovativeusers.org/t/report-for-avg-amount-saved-by-using-the-library/1929 "2024-07-11T13:24:31Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@smyoung877](https://forum.innovativeusers.org/u/smyoung877)
#### Post date: [July 11, 2024, 1:24pm UTC](https://forum.innovativeusers.org/t/report-for-avg-amount-saved-by-using-the-library/1929/1 "2024-07-11T13:24:31Z")
[We have the You Saved Receipt Messages turned on.]
At the Friends meeting tonight, they asked whether we could pull any data from Polaris as to the average amount patrons save by using the library. They hoped to use that data to advertise for the Friends (here’s what the average person saves at the library). Can I run a SQL or other report to get this data?
---
### Author:  [@ebrondermajor](https://forum.innovativeusers.org/u/ebrondermajor)
#### Post date: [July 11, 2024, 3:36pm UTC](https://forum.innovativeusers.org/t/report-for-avg-amount-saved-by-using-the-library/1929/2 "2024-07-11T15:36:24Z")
If I’m understanding your request correctly, an easy way would be to run
```auto
select avg(lifetimeyousavedamount) from patrons with (nolock)
```
I believe that would get you the average amount saved by all patrons since you started tracking the number. At our system, we have noticed that some prices are not entered accurately (e.g. barcodes entered instead of normal prices) which really distorts the count, so it might be worthwhile to just pull the list of You Saved amounts (not the average) so you can filter out any outliers and calculate the average manually (i.e. in excel).
This would show you just the numbers for this year:
```auto
select YTDYouSavedAmount from patrons with (nolock)
```
or last year’s numbers:
```auto
select YTDYouSavedAmount from PrevYearYouSavedAmount with (nolock)
```
Going back to years before last year is really time consuming but it can be done.
---
### Author:  [@wesochuck](https://forum.innovativeusers.org/u/wesochuck)
#### Post date: [July 12, 2024, 4:10pm UTC](https://forum.innovativeusers.org/t/report-for-avg-amount-saved-by-using-the-library/1929/3 "2024-07-12T16:10:21Z")
Great solution!
> [@ebrondermajor](#):
>
> At our system, we have noticed that some prices are not entered accurately (e.g. barcodes entered instead of normal prices)
Just a quick plug to vote for an idea that would prevent this from happening: [Set a maximum allowed price for items – Innovate with us](https://ideas.iii.com/forums/951742-ils-polaris/suggestions/46833076-set-a-maximum-allowed-price-for-items)
---
### Author:  [@annewynn](https://forum.innovativeusers.org/u/annewynn)
#### Post date: [December 31, 2025, 6:08pm UTC](https://forum.innovativeusers.org/t/report-for-avg-amount-saved-by-using-the-library/1929/4 "2025-12-31T18:08:58Z")
Does anyone have a similar report using SQL for Sierra?
---
### Author:  [@jmgold](https://forum.innovativeusers.org/u/jmgold)
#### Post date: [December 31, 2025, 6:18pm UTC](https://forum.innovativeusers.org/t/report-for-avg-amount-saved-by-using-the-library/1929/5 "2025-12-31T18:18:24Z")
[Sure do](https://github.com/Minuteman-Library-Network/SQL-Queries/blob/master/Custom%20reports%20site/checkout%20value.sql) (with the caveat that we only have 5 weeks of circ\_trans history in our system).