We encountered an error trying to save your calculated field: Rank Function

Question & Answer
,
1

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}

2

Hi @lenesian

Welcome to the QuickSight community!

Do you get an error message or it does not produce the results you expect? Can you elaborate a bit about the calculation with data and expected output?

Regards,
Giri

3

Hi @lenesian,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post or were you able to find a work around?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @lenesian,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!