I looked at both of those.. I am not sure how I would apply them since I am not trying to sort on a dimension or measure but a calculated field.
I think it might help if you calculate the rank function with the same formula and try to sort it.
Venkat, thank you for the reply.
Would it be possible to provide an example of what you mean by "calculate the rank function with the same formula"? I am not sure what you mean.