Help

Re: Rollup Average for Rating field

Solved
Jump to Solution
2752 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Kelly_Vorrasi1
6 - Interface Innovator
6 - Interface Innovator

Hi Folks, 

I'm trying out using the rating field for a ongoing review process and want to be able to roll up an average of those ratings. I've managed to get the rollup to work but can't get rid of the NaN for fields that don't have ratings yet. I've tried a couple different formulas that I've seen for similar questions but nothing seems to be working. Thanks!

1 Solution

Accepted Solutions
lindseypuccio
Airtable Employee
Airtable Employee

Sorry, Kelly! Let's do it backwards. 

IF(Average>1, Average) should work!

See Solution in Thread

5 Replies 5
lindseypuccio
Airtable Employee
Airtable Employee

You can solution this by rolling the field up, showing NaN, then creating a second field that is a IF formula, removing any items that are NaN. 

IF({Rollup-Field}="NaN", BLANK(), {Rollup-Field})

Kelly_Vorrasi1
6 - Interface Innovator
6 - Interface Innovator

I did try that and it's not working for some reason. Here's a picture of my formula and the two fields in question

average.jpg

lindseypuccio
Airtable Employee
Airtable Employee

Sorry, Kelly! Let's do it backwards. 

IF(Average>1, Average) should work!

That worked! Thank you!

Riccardo_Contur
4 - Data Explorer
4 - Data Explorer

I wonder if you can have the rollup formatted as "rating" as well (with the stars). Thanks!