I am looking to the find the average of the Goals For (GF) and have it show up as dynamic text. I have the data stored in the data type: Games.
I don’t understand how to get the sum of GF and divide it by the count of GF.
The math expression would be sum(GF)/count(GF) = (3+4)/(1+1) = 7/2 = 3.5
costas
2
Hi, just try to use the average fitting. No need to divide predators. Here is quick example from my app
costas
3
Though ignore after the (
Hope this helps. Sorry. Away from pc so just sent quick screen shot.
costas
4
Sorry. Meant ‘average’ setting/function.
There is no average setting unfortunately
![Capture3](https://global.discourse-cdn.com/bubble/original/3X/2/5/259861a7b731799635ddcc5e6dfa0e7d75fe7f9f.png)
![Capture4](https://global.discourse-cdn.com/bubble/original/3X/9/4/94039dca9e2496989a905dc385f8a836f234a1ad.png)
costas
6
How is the data field saved? Is it number?
costas
8
Do you have option for each items average?
1 Like
That solved it, thank you very much!
costas
10
No worries. Sorry. Away from pc ![:slight_smile: :slight_smile:](http://forum.bubble.io/images/emoji/twitter/slight_smile.png?v=9)
Glad you solved it.
1 Like