Hi! Iโm trying to create a very simple app for the tennis team at my school that can calculate the average win for the group as a whole. I can easily do this using Excell, but Iโm not able to properly format the formula in Appsheet. I can create all the table references and relationships, but Iโm not able to calculate the average from the columns in the โGamesโ table to the column in the average table. I even created a virtual column in the โGameโ table, but that didnโt work. Plus I want to be able to display the total average in a separate tab/window. Another problem I had was not being able to multiply by .5. Here is the Excel formula and a simple image of the tables: =SUM(B8/(B8+C8+(0.5*D8))*1000)
Start here:
I read all those explanations about expressions and deference expressions. And I fully understand how the โquote calculatorโ example works, but Iโm not able to take the values from the column โPlayer Averageโ in the โMatchesโ table and display it by itself in the table in the column โTeam averageโ in the โAverageโ table. I was able to do this app in Python in about 30-40 minutes, but Iโm not able to fully understand the syntax in appsheet to move those values around.
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |