[Solved] Calculate the average from the list

[stronazyskuup]

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?

[tatiang]

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

[jared]

Check out this recent post from Thunker @David_Wolber

Adding up numbers

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

[stronazyskuup]

Aha… sorry

[tatiang]

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.

[jared]

You can average a list. Would this help?

[manyone]

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)

[stronazyskuup]

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.

[muneer]

@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.

[stronazyskuup]

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?

[muneer]

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.

[stronazyskuup]

Omg… THX