In order to achieve the closeness to this requirement, I was able to use the CAST function to display one value after the decimal point. Here is my example. 7 in the following represents the number of valid digits and 1 is the number after the decimal point.
CAST(o_ips, AS DECIMAL(7, 1))
Furthermore, if that’s your requirement, you can convert the result from numeric value to string by using CAST over it. I found this info in the following manual. This should be helpful to you.
・Type Conversion Function [CAST](https://community.denodo.com/docs/html/browse/8.0/vdp/vql/appendix/syntax_of_condition_functions/type_conversion_functions#cast)
Hope this helps!