This issue is a little hard to explain, but I hope you will be able to understand what I am trying to ask. I believe my issue is that I format the formula in SQL incorrectly.
I need to have such a calculation namely f.TOTHIST / (f.TOTFCST - f.TOTHIST) - 1 which will give me Sales vs Forecast. I need to have this in a %.
How I typed in SQL
FORMAT(f.TOTHIST / (f.TOTFCST - f.TOTHIST) - 1, 'P0') AS 'Sales VS FCST'
This is what I get
20 / (20.002 - 20) cannot be 999.900%. It is not right.
Does someone have an idea what can it be?
Please let me know.
Thank you in advance.