Pivot Table Calculated Field to Assign Scores

troh3178

New member
Joined
Apr 18, 2016
Messages
1
Reaction score
0
Points
0
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!
 

Attachments

  • SampleReport.xlsx
    13.5 KB · Views: 22
@Herbds

Hi

please post your files on the forum instead of an external link. This deprives many members of an answer as not everyone is authorized to access those links. Thank you
 
Back
Top