Help

Dynamic ratio on a table

Topic Labels: Formulas
783 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

let us say that I have a simple table containg a list of products and the sale amount of each product. Now i want to add the share of sales of each product in this table.

The only way I found to do that is to create a new table called "Total". This table contains only 1 line and is linked to the product table in order to rollup the value Sales to compute and store the Total of sales accross all products. This total is then brought back by lookup into the table Product, meaning the a new formula field (Sales / Total) can be set up.

Problem is that this formula is not dynamic, meaning that if we filter the table, the share is not correct anymore since the total is not recomputed.

is there a solution do set up a computation with a dynamic total responsive to the filters applied on the table?

Thank you

Pascal

0 Replies 0