Format Editor Formula - Font Change???

[PQTIII]

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

 

[campsys]

Try this in the Font Color formula box:


if @Actual < @Forecast then crred
else
crblack

 

[Nuffsaid]

Hi,

It sounds like @Forecast is not returning a numeric value.
Try wrapping the formula in Tonumber.

Tonumber(@Forecast)


Nuffsaid.

 

[synapsevampire]

If it still errors, wrap both in tonumber.

-k

 

[dgillz]

Please post the formula for @forecast and @actual.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.srhconsulting.com

 

[lbass]

campsys' solution should work. I think the error message requiring a number refers to color number--you can either use crRed, etc., color(255,150,45), etc., or a number like 200.

-LB

 

[PQTIII]

When I try :

if @Actual < @Forecast then crred
else
crblack

It still says a number is expected.

When I tried:

ToNumber ({@Actual})<ToNumber ({@Forecast})

It says the formula result must be a number.


(@Actual) :If shared numbervar shifts > 0 then
{@Show Tons}/shared numbervar shifts else 0

(@Forecast) :If GroupName ({hist_loclist.region})="10W" then 138089 else
if GroupName ({hist_loclist.region})="9W" then 58426 else 0

Ex:
Region Crew Forecast Tons/Shift(Actual)
10w
A 138089 153211
B 138089 138222
C 138089 128000
9W
A 58426 48334
B 58426 52345
8W
D 0 3100

 

[campsys]

Try using this combination of the two. It should do it.


ToNumber ({@Actual})< ToNumber ({@Forecast})then crred
else
crblack

 

[PQTIII]

campsys

That worked just great, thanks!

Paul