Summary Method for Lookup function

Options
PalmHazel0531
PalmHazel0531 Member, ALL USERS, Partner, Certified Model Builder Posts: 1 New Contributor
in Planning & Modeling

Hi,

 

What is the best workaround when using the Lookup Function and you need a Formula Summary Method?

 

Currently, Anaplan does not allow this and for some cases, especially using % accounts, it is best to use the Formula aggregation in order to get the right math at top level hierarchies and Time Summaries (i.e, All Periods). 

PalmHazel0531_1-1636039658521.png

Thanks!

Tagged:

Comments

  • thanasis
    thanasis Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Occasional Contributor
    You can create a stage module in order to split the calculations and get the data faster

Categories