Number of reviews

Aug 24, 2009 at 4:58 AM

I try to calculate using the following formula:

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

however, it show me #value  value.

Please advise

Coordinator
Aug 24, 2009 at 5:46 AM

Hi,

There has been a discussion about that already...It's a mistake in the manual. Replace "vote(s)" by "rating(s)" and that will be ok.

Best Regards

 

Aug 24, 2009 at 7:52 AM

it works. thanks