Most rated Documents view

Jul 7, 2009 at 1:23 PM

Hi,

Im trying to get the most rated documents view using the formula

=IF([Vote Results]<>"",TRIM(MID([Vote Results],5,(FIND("vote(s)",[Vote Results])-5))),0)

in a new calculated column of type number.

But in the view i see the value of that column as

#value!

Am i missing something?

Coordinator
Jul 9, 2009 at 6:18 AM

Hi,

There is an error in the manual. You must replace "vote" by "rating" and it will be ok if you installed the solution in english

Best Regards

 

Jul 10, 2009 at 4:40 AM

Perfect: So the correct formula to get the Number of ratings per document shall be :

=IF([Vote Results]<>"",TRIM(MID([Vote Results],5,(FIND("rating(s)",[Vote Results])-5))),0)