Thanks @ekricha - Can you try to cast the fields to decimal (10,2) in your CTE tables and then do the division.
If it is not working, i will spend sometime to create a Redshift cluster and try it from my side.
Please check and share your outcomes.
Regards - Sanjeeb