Hello,
I have a field with a decimal value representing a percentage, actually I saw it as 0.21, but I want to see as a percent like 21.56%
How can I did it?
Thanks in advance
Like
3 comments
17:17 Aug 14, 2020
Hi Julius, thanks, but my question is how to format the decimal to a percent I need to display no just 21,56 I need 21,56%. Thanks again
23:13 Aug 14, 2020
Create a text field like UsrPercentage and make it a calculated field off of the percentage field. Use the following code inside of the desired page schema, but change UsrPlaceholder to your percentage field.
attributes: { "UsrPercentage": { dataValueType: Terrasoft.DataValueType.FLOAT, dependencies: [ { columns: ["UsrPlaceholder"], methodName: "calculatePercentage" } ] } }, methods: { onEntityInitialized: function() { this.callParent(arguments); this.calculatePercentage(); }, calculatePercentage: function() { const decimal = this.get("UsrPlaceholder"); const percentage = decimal * 100; this.set("UsrPercentage", `${percentage}%`) } },
This code does not handle percentages being converted back to decimal, so preferably this percentage field will be read only.
Show all comments