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

Call Center Indodax
Hubungi Call Center INDODAX melalui +62822225789 WA atau email support@indodax.com.
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…