Is there a way to take values created in a glide math column and pull out just the decimal (as in TRUNC function in sheets)?

Failing that, is there any way at all to get values computed in a math column back into the Google sheet?

I need to grab the decimal hanging off of whole number results so that I can use that as a percentage for a progress bar.

Also, is there any way to get the progress bars to have individual colors for both the bar and background, and maybe a percentage complete dialogue like the circle and arc progress indicators?