Using LOOKUP and SUM with Formula summary method

AndreyPol

A detailed description of the enhancement that is being requested.

We would like to request an enhancement that would allow to use LOOKUP and SUM with Formula summary method.

 

Currently Anaplan doesn’t allow to do so, although in many cases it is needed and doesn’t break the math.

 

If available, could you please provide a picture or an example of the enhancement when implemented?

 

For example here I use Last non-blank summary in Last Project column. I want Volume line item to take given Project each time on lowest level, but lookup for Last Project at Summaries:

If Formula summary would be possible, Volume at ISC – ID 2009 would be 1000 as in the last line above.

To provide more clarification, could you please explain how you hope the enhancement would assist in your business process(es)?

 

It would ease building of the modules, where business requires to take into account different reference at lower and higher levels, using complex criteria.

Miran

Status changed to: New

Noemi.andres

This would be a great addition, saving space for extra line items that are currently needed to get around this issue.

Nitika

I really liked this Idea. This would make our work more easier.

NabajitBharali

This is really needed.

PranayG

This issue still persists, has anyone been able to find a workaround for this? 

EDIT: found the workaround in this link : https://community.anaplan.com/t5/Anaplan-Platform/Summary-Method-for-Lookup-function/m-p/124086#M31229

frwegner

Is there an update on this being considered on the roadmap? We run into this issue a lot.