Page 1 of 1

Calculated Field as Percentage

Posted: 2020-04-15 19:12
by 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

Re: Calculated Field as Percentage

Posted: 2020-04-16 03:06
by jangle
I also tried uses hooks but with no success.....

Thanks in advance.

Jim

Re: Calculated Field as Percentage

Posted: 2020-04-16 03:12
by 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

Re: Calculated Field as Percentage

Posted: 2020-04-17 23:04
by bescott53
Could you use CONCAT

Re: Calculated Field as Percentage

Posted: 2020-04-22 13:24
by 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