# Get an average of scores from Airtable

**URL:** <https://community.thunkable.com/t/get-an-average-of-scores-from-airtable/1595500>\
**Category:** Questions about Thunkable X\
**Tags:** beginner\
**Created:** [November 3, 2021, 1:22pm UTC](https://community.thunkable.com/t/get-an-average-of-scores-from-airtable/1595500 "2021-11-03T13:22:01Z")\
**Posts on this page:** 1\
**Showing post:** 15

<div class="post-metadata">

**Author:** ![mimostel](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/mimostel/32/107661_2.png) [@mimostel](https://community.thunkable.com/u/mimostel)\
**Post date:** [November 4, 2021, 8:54am UTC](https://community.thunkable.com/t/get-an-average-of-scores-from-airtable/1595500/15 "2021-11-04T08:54:44Z")

</div>

> [@brunospavei2kqs](#):
>
> It’s almost work. I don’t know if the average is right, maybe it’s working just for last 2 scores.

You may easily manually check. Using average as integer when it comes to pretty same NOTES will round the result. You get much more accurate average value if you will use 2 decimals instead.

> [@brunospavei2kqs](#):
>
> And the average happen slow, I really don’t know when.

See this:  
[Using LocalDB as source of DVL - Thunkable Discuss - Community](https://community.thunkable.com/t/using-localdb-as-source-of-dvl/1589677/4)  
and you will see that I’m complaining about the speed when using local tables too. For Airtable, GoogleSheets is even worst when it comes to do calculations with large data…  
@domhnallohanlon promised me that will provide an answer so I’m confident 😊

Maybe in your case you can implement some trick that @muneer taught us, about making another filtered sheets from original sheets in Airtable, then use that for DVL. This way you can sum directly an entire column from filtered and speed up the app.

---

_[View the full topic](https://community.thunkable.com/t/get-an-average-of-scores-from-airtable/1595500)._