Calculated Field as Percentage
Posted: 2020-04-15 19:12
Hello All,
I have looked for this answer, but the project is somewhat time sensitive so I am hoping for a little direction.
I have a read only calculated field in my app with a type of decimal 3, 2.
My sql is
it works fine but the value shows as for example 50.000. I would like it to sure 50%. I have tried to add SELECT FORMAT been then it did not work.
Please and help appreciated.
Jim
I have looked for this answer, but the project is somewhat time sensitive so I am hoping for a little direction.
I have a read only calculated field in my app with a type of decimal 3, 2.
My sql is
Code: Select all
SELECT
((`Workforce_Impact_Survey`.`workforce_out` / `Workforce_Impact_Survey`.`Total_operational_Workforce`)*100)
FROM `Workforce_Impact_Survey`
WHERE `ID` = '%ID%'
Please and help appreciated.
Jim