How can I find average value of a number in a user specific column

[Jeff_Hager]

To echo what @Eric_Penn said, you would have to build in some more logic to calculate the average. Something like this.

Averaging Rating Data

You can do it in a separate screen like this. [image] [image] You would store the rating to a user-specific column that only serves as a temporary storage on the second screenshot. Let’s call it “temporary rating”. Force users to make a decision whether to “submit” or not. If they press submit you write that value to another column “permanent rating”, also a user-specific column. Serves only as a way to show the rating to the signed-in user later on. Now for the average, it gets a bit comp…

Obviously, it would be a whole lot easier to have a row for each user. Actually, if you have user profiles enabled, then you could just reuse the existing user profile table, display the screen based on the user table, and store the results on each user row. That way you can use a normal rollup → average on all rows in the table, without trying to figure out how to pack multiple results into one row.

Otherwise, you’ll have to build some sort of submission process that would update a total and a count column, but you would also have to account for any time that a user removes their rating or updates it, which means you would have to remove and recalculate the totals based on the old rating before updating with the new rating.