How to divide a list item value by the total list items value ?

Accepted answers

Here's one of the below example to do:

Regards,

Jagadish

Here's one of the below example to do:

Regards,

Jagadish

You should use [SELECT:] function for this.

The formula would look something like this:

<value line item>/<value line item>[SELECT:<list_A>.<Total Item>]

where:

<value line item> - is your line item to calculate the ratio

<list_A> - list name

<Total Item> - Total item name of <list_A>

Thanks for the answer. I was also finding if there is some other way than using SELECT.

If for some reason you do not want to set the top-level summary, you can create another module and sum over all items.

Then use the LOOKUP function to get the sum back.

Taichi

How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…