# \[Solved\] Calculate the average from the list
**URL:** https://community.thunkable.com/t/solved-calculate-the-average-from-the-list/1658882
**Category:** Questions about Thunkable X
**Tags:** solved
**Created:** [December 22, 2021, 9:47pm UTC](https://community.thunkable.com/t/solved-calculate-the-average-from-the-list/1658882 "2021-12-22T21:47:51Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 22, 2021, 9:47pm UTC](https://community.thunkable.com/t/solved-calculate-the-average-from-the-list/1658882/1 "2021-12-22T21:47:52Z")
I need to calculate the average from this list. everything works, but the variable is overwriting and I have to turn the applications off and on for the calculations to be correct. What can I do with this?
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [December 22, 2021, 10:31pm UTC](https://community.thunkable.com/t/solved-calculate-the-average-from-the-list/1658882/2 "2021-12-22T22:31:48Z")
We can’t help you without seeing a screenshot of your blocks or a link to your project.
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [December 22, 2021, 11:01pm UTC](https://community.thunkable.com/t/solved-calculate-the-average-from-the-list/1658882/3 "2021-12-22T23:01:24Z")
Check out this recent post from Thunker @David_Wolber
> [@Adding up numbers](https://community.thunkable.com/t/adding-up-numbers/1658861):
>
> [Video Tutorial](https://draganddropcode.com/add-the-numbers-in-a-spreadsheet/) showing how to add up numbers in a spreadsheet, e.g., compute an average rating. Learn basics of repeat blocks, if blocks, and how apps add. The app uses drag and drop interface
---
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 22, 2021, 11:21pm UTC](https://community.thunkable.com/t/solved-calculate-the-average-from-the-list/1658882/4 "2021-12-22T23:21:31Z")
Aha… sorry 😉
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [December 23, 2021, 2:06am UTC](https://community.thunkable.com/t/solved-calculate-the-average-from-the-list/1658882/5 "2021-12-23T02:06:47Z")
Okay, well that function will add each list item to create a **sum** , not an average. If you want an average, then you need to do `set app variable total to app variable total + j` (or just `change app variable total by j`, which does the same thing) and then below the loop, `set app variable average to app variable total/length [list of values in payments history in Table 1 in price]`.
If you have the data in Google Sheets or Airtable already, you can just use a formula to get the average. But if the data is in a local data source, you’ll need a function like you’re using.
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [December 23, 2021, 2:15am UTC](https://community.thunkable.com/t/solved-calculate-the-average-from-the-list/1658882/6 "2021-12-23T02:15:46Z")
You can average a list. Would this help?
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [December 23, 2021, 9:09am UTC](https://community.thunkable.com/t/solved-calculate-the-average-from-the-list/1658882/7 "2021-12-23T09:09:30Z")
after all these years, i never noticed that you could do sum, average, etc and other list-related functions with ready-made blocks!!! i always had to write a sum function everytime i needed one! (i was looking for sum in the math blocks but there was none)
---
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 23, 2021, 9:34am UTC](https://community.thunkable.com/t/solved-calculate-the-average-from-the-list/1658882/8 "2021-12-23T09:34:57Z")
below I have unpinned blocks that define the length of the list and divide the sum by these blocks. my blocks calculate the mean but overlap in the variable. I have to turn off and turn on the Application for the result to be correct. every time i use the “average” function everything is x2 and so every time the function restarts. only resetting the app helps. I don’t know how to stop it.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [December 23, 2021, 10:56am UTC](https://community.thunkable.com/t/solved-calculate-the-average-from-the-list/1658882/9 "2021-12-23T10:56:15Z")
> [@manyone](#):
>
> i never noticed that you could do sum, average, etc
Sometimes it is a good idea to have your own functions.
Try the `sum` or `average` on the block like this
You will see that it does not work and you will revert to building your own function. Lists generated from `Data Sources` default to **text** and therefore the calculation functions do not work with them.
---
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 23, 2021, 11:42am UTC](https://community.thunkable.com/t/solved-calculate-the-average-from-the-list/1658882/10 "2021-12-23T11:42:55Z")
here all the blocks. the function works, but the computations overlap each time I want to use it. If that’s not possible, how else can I build such a function?
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [December 23, 2021, 2:07pm UTC](https://community.thunkable.com/t/solved-calculate-the-average-from-the-list/1658882/11 "2021-12-23T14:07:10Z")
Inside your `average` function, the first block should be `set app variable average to 0`. This will ensure that the average is not being added up every time.
---
### Author:  [@stronazyskuup](https://community.thunkable.com/u/stronazyskuup)
#### Post date: [December 23, 2021, 3:42pm UTC](https://community.thunkable.com/t/solved-calculate-the-average-from-the-list/1658882/12 "2021-12-23T15:42:15Z")
Omg… THX
---
### Author:  [@system](https://community.thunkable.com/u/system)
#### Post date: [March 23, 2022, 3:43pm UTC](https://community.thunkable.com/t/solved-calculate-the-average-from-the-list/1658882/13 "2022-03-23T15:43:09Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.