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.
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!