Description of the enhancement required:Raise limit on RANK function while maintaining adequate performance.
How would it help your business process: We've been seeing more incidents where customers are hitting the cap placed on RANK and similar functions.
The cell limit of the RANK function has been increased to 50 million cells. If more than 50 million cells are used with the RANK function, the model rolls back and a notification displays.
The 50 million cell limit does not account for summarized values or the Time and Versions lists. This means you can use the RANK function with a line item with a Cell Count of greater than 50 million cells if there are less than 50 million nonsummarized cells.
As the number of cells you use with the RANK function increases, so does the duration of the calculations.
Thanks for submitting your idea!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.