Rank Cell Limit Clarification

cmast

Hello,

I see there is a 50M cell limitation on being able to use the rank formula. I'm trying to clarify what I look at to determine if the line item I want to rank would be under or over the limit?

For example, Do I look at the Cell Count of the line item I'm trying to rank or is it different?

Second, I see in the Planual, it mentions not to rank on a large list. Does the 50M cell limitation and Planual correspond to each other or two separate items?

If they are two separate items, what would be considered a "large list"?

rob_marshall

@cmast

Yes, the cell count of the line item containing the Rank formula has to be less than 50M cells. And yes, both rules are the same, but honestly, your list shouldn't be 50M members if you don't have Time in the code or as a property (another Planual rule). If you do have Time as part of the list, I would suggest reading this article.

https://community.anaplan.com/discussion/48866/oeg-best-practice-data-hubs-purpose-and-peak-performance