Calculated Field as Percentage

[jangle]

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

Code: Select all

SELECT
((`Workforce_Impact_Survey`.`workforce_out` / `Workforce_Impact_Survey`.`Total_operational_Workforce`)*100)
FROM `Workforce_Impact_Survey` 
WHERE `ID` = '%ID%'

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

[jangle]

I also tried uses hooks but with no success.....

Thanks in advance.

Jim

[jangle]

Ok I fixed the format problem by changing the data type for the two fields that create the calculation.

Now just to add the '%" sign

[bescott53]

Could you use CONCAT

[jangle]

Hello thanks, I did try that but it did not work.... But that's ok it is good how it is for now.

Thanks very much for responding.

Jim