Formula to get the percentage contribution of each record

[astroboy]

 Hello, I would like to create a formula/calculation that will allow me to show what percentage each record into a field contributes to the total sum of that field. Is that possible in Caspio?

[princezuko]

You may try this formula, however, this only works on the DataPage level:

([@field:NumberField]/(SELECT SUM (NumberField) From Table))*100

Please make sure to replace the field names according to your table design.

[astroboy]

Just now, princezuko said:

You may try this formula, however, this only works on the DataPage level:

([@field:NumberField]/(SELECT SUM (NumberField) From Table))*100

Please make sure to replace the field names according to your table design.

This works! But I have another question.

I noticed that it is calculating the percent contribution to the entire table but I only want to calculate the percentage for the displayed data which is being filtered by another field, say a company name.

[princezuko]

If you want to calculate the contribution for a specific filter, you may try adding a Where criteria that utilizes 'target'.  You may refer to this formula:

(([@field:NumberField]/(SELECT SUM (NumberField) From Table))*100 WHERE Company_ID=target.[@field:Company_ID]))