+9Hi 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!
Best answer by lindseypuccio
Sorry, Kelly! Let's do it backwards.
IF(Average>1, Average) should work!
+3You 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})
+9I did try that and it's not working for some reason. Here's a picture of my formula and the two fields in question
+3Sorry, Kelly! Let's do it backwards.
IF(Average>1, Average) should work!
+9Sorry, Kelly! Let's do it backwards.
IF(Average>1, Average) should work!
That worked! Thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
