Pivot Table Calculated Field to Assign Scores

[TROH3178]

Hi! I'm trying to assign a scoring system to a set of percentages in a pivot table. I'm running into problems when there is a roll-up (one person has multiple results rolling up to them). How do I get the calculated field to read the roll up value and assign the score? The formula in the calculated field is

= IF('Qualtiy Average' >0.95, 5, IF('Qualtiy Average' >0.9, 3, 1))

I have a roll up average of 89%, and it’s scoring it a “5”.

Thanks for any assistance!

 

[Sandler]

I took a look at your formula and used it on a B1 cell. .89 came out to 1.
= IF(B1 >0.95, 5, IF(B1 >0.9, 3, 1))
So, we know the formula is good.
Send over the example of the actual roll-up.

 

[TROH3178]

I'm new to this forum, and not quite sure how to send over my example....