Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Rollup Average for Rating field

Solved
Jump to Solution
151 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Sorry, Kelly! Let's do it backwards. 

IF(Average>1, Average) should work!

See Solution in Thread

4 Replies 4

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})

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

Sorry, Kelly! Let's do it backwards. 

IF(Average>1, Average) should work!

That worked! Thank you!