typescast string apha numeric to number in postgresql code example
Example: cast as decimal postgresql
cast (Non_Updated as decimal) / Total_Devices AS Percent_Failure
cast (Non_Updated as decimal) / Total_Devices AS Percent_Failure