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”.
If it's not possible with the calculated field, any other suggestions?
Thanks for any assistance!
= 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”.
If it's not possible with the calculated field, any other suggestions?
Thanks for any assistance!