Tried finding answer in docs and couldn't. I have a simple formula column setup showing x/y that divides amount collected into the total amount billed and I would like for the calculation to show as a percentage to see the percent of collections. Is there a way to make the 2 decimal number show as a percentage without the decimal? Right now if I put the % sign in as a suffix it will show .90% instead of 90%
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;
One formula column cannot be used in another. This limitation can be avoided by using nested calculations.
Adding a sum in the sum row for formula columns is not yet supported.
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.
Tried finding answer in docs and couldn't. I have a simple formula column setup showing x/y that divides amount collected into the total amount billed and I would like for the calculation to show as a percentage to see the percent of collections. Is there a way to make the 2 decimal number show as a percentage without the decimal? Right now if I put the % sign in as a suffix it will show .90% instead of 90%
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;
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.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables