Hello I am attempting to save a calculated field that ranks the sum of rank. I have created the field two times using the same format but for some reason it’s not working for this formula. I am even able to add the rank weights calculated field with another rank weights calculated field and rank it. But I just cant rank this formula for some reason…
Calculated Field Not working:
rank([{Compliance Weights Added} ASC])
Compliance Weights Added Formula:
{Rank Weight 4WK Actions Completion} + {Rank Weight 4WK CC Completion} + {Rank Weight YTD Actions Completion} + {Rank Weight YTD CC Completion} + {Rank Weight Expired Restrictions}