The color of money

[winklestork]

If I apply TextColor to a calculation that returns a numeric value in a field that is formatted as currency in the layout, the color doesn't appear. If I change the calculation result to text, the color appears but the currency formatting doesn't.

result=

// maximum_value is the numeric result of a calculation

// actual_value is numeric field entered by user

Let ( DELTA = maximum_value - actual_value;

Case(

DELTA < 0;

DELTA; RGB(255;0;0));

DELTA

)

)

How do you set the color of money?

Duh! After I posted this I realized that the number format provides an option for coloring negative. How do you retract a post?

Edited June 24, 2006 by Guest