Issue with the change of the column precision to be 2 decimal places-CodePudding

I need to change the % sales vs forecast column precision to be 2 decimal places instead of whole numbers. The confusing part is that I already have a format function and 'Po' as a '%" at the end, so I am trying to understand how I can make a % with two decimal points keeping this '%' sign in the field as well.

My formula:

FORMAT((f.TOTHIST - f.TOTFCST) / f.TOTFCST, 'P0') AS 'Sales VS FCST'

How I have now

If someone can help me how to adjust it and make it for example in the result as 48.88% instead of 49% that would be great!

Thank you!!

CodePudding user response：

This format works fine:

SELECT FORMAT((f.TOTHIST - f.TOTFCST) / f.TOTFCST,'#,##0.00%')