Hello Everyone,
I have a report that calculates a percentage based on 2 figures. For Example, Actual_count = 15000 and forecast_count = 14900. To calculate the percentage i use the following SQL statement
select ROUND(((ACTUAL_COUNT-FORECAST_COUNT)/FORECAST_COUNT)*100,1) as "PERCENTAGE" from table
This gives me the result of "-.7". This is the correct answer but what i would like is for the answer to display "-0.7".
Obviously i only want this when the percentage is minus, when it is plus it is not a problem.
The reason i want this is because it is easier to read, my manager has been confusing the figures thinking that the minus figures are the plus figures (apparently his eye sight is not what it was 8-P).
Would this be possible?
Thanks in Advance,
-N.S.N.O.