Summary Method for Lookup function



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). 



Best Answer

  • @PalmHazel0531 


    Give this a try, create another line item, call it Staging, where you get the summation or the value for the lookup and turn the summaries off.  In the line item you are wanting to use with the Formula summary, reference the Staging line item.




  • You can create a stage module in order to split the calculations and get the data faster
  • Pull in both sides of the % into separate line items, set these to SUM and use RATIO as your summary method. Use the two new line items in the ratio settings.