Summary Method for Lookup function

PalmHazel0531
New Contributor

Summary Method for Lookup function

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!

1 ACCEPTED SOLUTION

Accepted Solutions
rob_marshall
Moderator

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

 

Rob

View solution in original post

3 REPLIES 3
rob_marshall
Moderator

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

 

Rob

thanasis
Occasional Contributor

You can create a stage module in order to split the calculations and get the data faster
ChrisAHeathcote
Community Boss

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.

Chris
HeathcoteAndHerran.com