Editing Class function

[williamyuen96]

Hi guys, I ran problem where I succeed in implementing Class function into my ratings charts but the highest rating I have in the data set is 10. 

The syntax i used is as below 

=replace(class(Ratings,2),'<= x <', '-')

How do i edit this pie chart to ends at 8-10 instead ? Since the ratings in the data set is fixed at 10 as the highest

[tresesco]

Try putting a condition like:

=replace(class(if(Ratings<=10,Ratings),2),'<= x <', '-')

[williamyuen96]

Does not work unfortunately

[marcus_sommer]

I think there is just the else-branch from the if-loop missing, just try it with:

=replace(class(if(Ratings<=10,Ratings, 10),2),'<= x <', '-')

- Marcus

[williamyuen96]

Still doesn't work.. here, u could try it. I uploaded the qvf 

[wcilliers]

Try this...

=replace(class(if(Ratings=10,9.9,Ratings),2),'<= x <', '-')

[wcilliers]

=replace(class(if(Ratings=10,9.9,Ratings),2),'<= x <', '-')