Hi Ryan,

1. If you wish to remove decimal points from a Formula Column, you can do this by setting the Decimal places to zero in the Data settings.

Here is an example, from our Demo Sandbox Site, if we have some beverage sales data, and we wish to divide Column A/ by Column B - this is the initial result with 2 decimals :

And now, if I remove the decimals, set them to zero - the Plugin will round up each number to a value without decimals :

2. So if you just place a prefix or suffix, this does not affect the way how the actual value for each cell calculates, it only adds a visual percentage symbol next to the data.

-

If you wish to achieve an actual percentage calculation via a Formula, in that case, you need to create some formula which will show percentage values.

I am just not sure exactly what kind of percent of collections you wish, as you described, but we had a previous ticket where a user asked something similar.

For example, if you take the Total SUM number and place the number in a Formula manually - that is the only way to use a SUM in a Formula column at this time;

because currently for our plugin, these are the limitations for Formula columns;

1. One formula column cannot be used in another. This limitation can be avoided by using nested calculations.
2. Adding a sum in the sum row for formula columns is not yet supported.
3. Using calculation functions in formula columns is not possible

and we are also unable to "take a SUM number", and to use it anywhere else as part of other calculations;

we can only display it ( under the column, or with shortcode anywhere else on site).

-

So, for example, if i make a table like this :

And if i take the SUM into the Formula, to make percentage column, we use a Formula like this :

Then, if we filter the table,  the Formula column is still going to use that "fixed number" that we input ( in my case 8) ...

In other words, if you wish to get a 'true percentage' calculation like that, you will need to manually construct it in a Formula, similar to my example.

I hope that helps, let me know if you have additional questions.

Thank you.