I have a problem with simple styling when dynamically changing the numeric format.

This fex works well, total sales above 40,000 are highlighted in green:

TABLE FILE CAR
SUM
SALES
BY COUNTRY
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=SALES, COLOR=GREEN, WHEN= SALES GT 40000, $
ENDSTYLE
END

This fex does not works well, total sales above 40,000 are not highlighted in green:

TABLE FILE CAR
SUM
SALES/D20
BY COUNTRY
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=SALES, COLOR=GREEN, WHEN= SALES GT 40000, $
ENDSTYLE
END

I tried referring to SALES by using SALES(*) and SALES(2) but neither work. Am I missing something simple?

Thanks,

This message has been edited. Last edited by: Francis Mariani,

The line refers to SALES twice.

The second (for WHEN) will refer to the underlying column (it's really a matter of indifference which it refrs to)

The first needs to point to the reformatted column. Try COLUMN=P2

Thanks Jack.

Interestingly, this works:

TABLE FILE CAR
SUM
SALES/D20
BY COUNTRY
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=SALES, COLOR=GREEN, WHEN= SALES(1) GT 40000, $
ENDSTYLE
END

TABLE FILE CAR
SUM
SALES/D20
BY COUNTRY
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=N2, COLOR=GREEN, WHEN= N2 GT 40000, $
ENDSTYLE
END

I try to never use positional notation like N2...

Cheers,