Rollup Average for Rating field

[Kelly_Vorrasi1]

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!

[lindseypuccio]

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]

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

[lindseypuccio · Accepted solution]

Sorry, Kelly! Let's do it backwards. 

IF(Average>1, Average) should work!

[Kelly_Vorrasi1]

That worked! Thank you!

[Riccardo_Contur]

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