Style not working to show negative numbers in red

[rasinc]

Based on some research, it appears the typical method of showing negative numbers as red is to setup a conditional style.

I have a variable in a group footer that calculates inventory availability.  I set up a style with the expression

$V{Available}<0.00

and red as the forecolour (255,0,0).

However, when I run the report, the style doesn't change the forecolour.

I'm not sure what to do to get this to work, or is this the correct approach?

TIA, rasinc.

[bigalex]

Try expression:

new Boolean($V{Available}<0.00) ? "<style forecolor='red'>" + $V{Available} +"</style>": $V{Available}

Don't forget to  set Markup in Text Field to <styled> 

[rasinc]

Thanks bigalex.  However, I am getting weird errors.  When I have the report language set to Java as I understand I should when using Fishbowl Inventory, I am getting the error when running the report directly in iReport.

The operator < is undefined for the arguement type(s) BigDecimal, double.

I get other errors when it is set up as javascript.

I can't believe how frustrated I am with this language but I expect that I am just missing some bit of logic.