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? [20211222_223611]

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.

We can’t help you without seeing a screenshot of your blocks or a link to your project.

Check out this recent post from Thunker @David_Wolber [image] Adding up numbers Questions about Thunkable Video Tutorial 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

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.

You can average a list. Would this help? [image]

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) [image]

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.

[image] 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 [image] 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.

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? [20211223_123859]

[Solved] Calculate the average from the list

Questions about Thunkable X

jared December 22, 2021, 11:01pm 3

Check out this recent post from Thunker @David_Wolber

Topic		Replies	Views
Creating a list with numbers and make an average Out of them Questions about Thunkable X beginner , listview	3	395	February 19, 2023
'Average of list' block not working correctly? Questions about Thunkable X list , average	2	733	April 1, 2020
How to add all values in Google Sheets? Questions about Thunkable X	13	1259	April 15, 2021
Adding up numbers Questions about Thunkable X	0	381	December 22, 2021
Get an average of scores from Airtable Questions about Thunkable X beginner	22	1268	November 7, 2021

[Solved] Calculate the average from the list

Related topics