PQTIII
IS-IT--Management
- Sep 21, 2004
- 110
I'm using an if-then statement to get @Forecast number (can be 1 of 2 numbers) and a formula to get an @Actual number. Once I get these two numbers I compare them and if @Actual < @Forecast I want the @Actual to show red. I've tried a formula in the Format Editor of the Format Field option. I check the Font Color and put @Actual < @Forecast in the formula box, but this will not work. It says that @Forcast must be a number. Is there another way to do this?
Thanks Paul
Thanks Paul