Skip to main content
Solved

Calculate average in interface

  • October 8, 2024
  • 3 replies
  • 188 views

Forum|alt.badge.img+5

Hey I'm quite new but couldn't find an answer : I'm looking to show the average of a column in the interface. To be specific, I have a set of data from one table and I'm selecting certain data from another table, and I want to calculate the average of specific values from this other table in the interface. (It's for managing events, so I have a list of events in one table and another table with all our members and for example their age, and I select the participants in the specific activity and want to be able to calculate the average for example of the age of the participants from the list of members).

Hope it's kinda clear, thanks!!

Best answer by TheTimeSavingCo

What if you created a rollup field and displayed that in the Interface instead?


Link to base

3 replies

ladla_karan
Forum|alt.badge.img+6
  • New Participant
  • October 8, 2024

It's a bit unclear if the average is required on the complete column or linked records in the events table.

Kindly attach the screenshot of the tables to help us help you better.


TheTimeSavingCo
Forum|alt.badge.img+31

What if you created a rollup field and displayed that in the Interface instead?


Link to base


Forum|alt.badge.img+5
  • Author
  • New Participant
  • October 9, 2024

Thats perfect thank you very much!