Remove 10 million item limit from the ISFIRSTOCCURRENCE function


Brief description of the idea

Remove 10 million item limit from the ISFIRSTOCCURRENCE function


Expected benefit/impact

Removing this limit would allow imports to be ran into large hierarchies that are referenced in ISFIRSTOCCURRENCE formula. Currently they fail with an error message.

34 votes

Delivered · Last Updated


  • Status changed to: Delivered
  • Rebecca
    Status changed to: Delivered
  • We have a lot of processes at our clients that will run just fine for months or years, and all of a sudden start failing due to this, when a record list hits 10M records. Would love to see this addressed, as it creates a lot of work and uncertainty / issues with reliability for our clients.

  • Hi!


    It would be really useful for the 10 million items limit for isfirstoccurence to be lifted. 



    If the product team could comment on why this is? (I believe it is due to performance implications and if it is there better way to achieve this on large data sets?)





  • @usman.zia 

    hang tight

    Coming soon hopefully


  • Thanks @DavidSmith I can't wait for that to come!

    No expected performance implications? 

  • Miran
    Status changed to: Delivered
  • Not so far in testing, we may introduce some limits as a cautionary measure - We are testing out different limits


  • Status changed to: Delivered
  • this could be really helpful when big extractions from ERP systems at a very detailed level needs to be imported in Anaplan and are used to update the lists from these extractions. 


    the summary modules are working...but updating the lists it can become a little difficult to find workarounds: using different lists, sub-sets...etc. 


  • This is now delivered - The limits were increased to 50 Million in May

  • This is now done - The limits were increased to 50M in May

  • Status changed to: Delivered
  • Reviving this thread - Any color on how 50 million was determined? This still seems low - for example a large company simply building lists off a 50 million item GL transaction list - yes that is not Planual ideal but we rarely live in a perfect world..

Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!