Calculations with every new submission

[jesschrist]

i have a star rating system in an app. the owner wants an average for all ratings submitted for each item. How do I separate the average by item and set to recalculate with every new submission

[david]

Create a relation from each item to all of its ratings, then use a roll-up on that relation to calculate the average rating per item.