This is seriously baking my noodle...
I have two numbers, a target and a forecast. They can each be positive or negative numbers. I need to figure out the percentage difference between them but I'm getting myself down the wrong route I think and could really do with another perspective.
The problem is that say for example the target is -5000 and the forecast is +50000. I then want a positive 1000% result, but simply dividing 50000/-5000 gives me -1000%, which doesn't look so good.
Conversly, if the target is -5000 and the forecast -15000, I want a negative -300%. And if the target is -5000 and the forecast 0, I need a positive result (not quite sure how that would work...).
Does that make sense? Basically the percentage difference between two numbers...
I have two numbers, a target and a forecast. They can each be positive or negative numbers. I need to figure out the percentage difference between them but I'm getting myself down the wrong route I think and could really do with another perspective.
The problem is that say for example the target is -5000 and the forecast is +50000. I then want a positive 1000% result, but simply dividing 50000/-5000 gives me -1000%, which doesn't look so good.
Conversly, if the target is -5000 and the forecast -15000, I want a negative -300%. And if the target is -5000 and the forecast 0, I need a positive result (not quite sure how that would work...).
Does that make sense? Basically the percentage difference between two numbers...