How to divide a list item value by the total list items value ?
Best Answer
-
2
Answers
-
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>
1 -
Thanks for the answer. I was also finding if there is some other way than using SELECT.
0 -
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
0