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

Thanks!

Accepted answers

rob_marshall

@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

All comments

rob_marshall

@PalmHazel0531

Rob

thanasis

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

ChrisAHeathcote

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.

shubhamrawat

Add an additional line item for staging, use it to grab the data from Lookup, set the summary for this to SUM, now reference this staging line item directly to the Final line item where you want the data and set the summary to formula for this line item. :)

kberger1

This is great! I was able to use a line item to reference a prior year month (summary = none) then "lookup" the amount from that period (summary = sum) and pull into another module to get the summary to work with Formula, closing balance and get a variance for year over year with correct totals for my dimensions and hierarchies. - Thanks!

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…