Skip to Content
0
Former Member
Dec 27, 2011 at 10:35 AM

Change Font Color of crosstab field

234 Views

Hi,

Want to change the font color based on condition like when value is negative then display in RED color else display it in BLACK color.

Please note the data type used for this crosstab field is String as I need to display negative value in parenthesis

Example:

-20 should be displayed as (20) and -45.34 % should be displayed as (45.34%)

I am able to achieve above scenario through u201CHighlighting Expertu201D of crosstab field.

Formula used

Value < 0 then font color = red

Value > = 0 then Font Color = Black

But the issue is when the value is not found m retrieving u2018-u2018to display in cross tab. Since the field is string, itu2019s treating u2018-u2018in first condition & displaying hyphen also in RED color.

I tried to used below formula in Font tab of u201CFormat objectu201D of crosstab field but m not getting expected result

Formula:

If INSTR ({Value from data table}, u201C(u201C) = 1 THEN

RED

ELSE

BLACK

Is it possible to display hyphen in Black color?

Please help... Itu2019s urgentu2026

Thanks,

ThakurS