How to display an Equation as %

[tim.young]

Hey @mdykstra,

A couple things you could do…

1. Use this as your equation field formula…({Total Pre-Test Completed}/{Total Submitted})*100 and set the decimal places to 2

2. Use option 1 + a text formula field {Percentage Formlua}% You could use this field as a display only field and the actual equation field for calculations since the equation field can be set as a number.

3. I just discovered this and started using it. Using an equation field to calculate percentage and simultaneously build an HTML progress bar using the <progress> tag.

CONCAT('<progress',CHAR(32), 'value="',({Total Pre-Test Completed}/{Total Submitted})*100,'"',CHAR(32),'max="100"></progress>')