percentages of a line

Hi:

Apologies for the simple question but we are new at this!!!

I need to work out how to work out the % of a item in a line.

Using an excel equation it will be sometime like - a2/sum(a2:a5)

I am sure it is something very straight forward but having no joy so far!!

Many thanks for the help in advance!!

Accepted answers

Hi,

I have created a simple example with a list "List A" that rolls up to the list "Parent List A", proposing two different approaches:

- Percentage in 1 step using the SUM & LOOKUP

- Percentage in 2 steps breaking the SUM & LOOKUP in two steps with the help of an extra line item "Amount Total" (Suggested approach)

Blueprint

Grid View

I hope this helps

Regards,

Antonio

JaredDolich

Just try to avoid line items that use sum and lookup in the same formula. These are not very efficient formulas.

If you use the DISCO methodology, which is highly recommended, the parent lookup should be in a system module. "Calculate once", "Reuse Often".

In this example "division" is in the same module but really belongs in a system module.

Screen Shot 2019-10-21 at 8.39.11 AM.png

If you are needing a the sum to be dynamic (say three months forward), then MOVINGSUM is good for that.

Also, if it is the year end number you want, use a time settings module that holds, say FY2019, as a formatted line item

You can then write

line item/line item[LOOKUP:Time Settings.Lookup value]

I hope that helps

David

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385