I'm having a problem getting the evaluate function to work properly with textColor. The basic format of what I'm trying to do is

case (isempty(OverRidePrice); BigSumOfOtherStuff; textcolor(evaluate(OverRidePrice);rgb(255;0;255)))

The field result is a number. It works if I set the field result to text. How can I get it to work with the field result as a number? I've tried messing around with getAsText and getAsNum functions, but without success.

Thanks for any insights,

Dan

Hey there,

I'm having a problem getting the evaluate function to work properly with textColor. The basic format of what I'm trying to do is

case (isempty(OverRidePrice); BigSumOfOtherStuff; textcolor(evaluate(OverRidePrice);rgb(255;0;2 55)))

The field result is a number. It works if I set the field result to text. How can I get it to work with the field result as a number? I've tried messing around with getAsText and getAsNum functions, but without success.

Thanks for any insights,

Dan

Is this the calculation for OverRidePrice and if so what is the evaluate function neede for?

TextColor only works with text. I am curious, though, what the purpose of Evaluate(OverRidePrice) is. Is there a formula or number in OverRidePrice?

TextColor only works with text.

You don't mean that it doesn't work with numbers do you Queue?

I use text color all the time in number fields.

Ah, you are correct. It works as long as you do not format the number field otherwise.

TextColor only works with text. I am curious, though, what the purpose of Evaluate(OverRidePrice) is. Is there a formula or number in OverRidePrice?

Thanks, that's what I was concluding. Maybe FM8 will have true condition formatting. I've created another calc field whose result is a container, so if the condition is met it displays a yellow block which highlights the field. Good enough as a workaround.

OverRidePrice is a text field where the user can enter their own calculation. Instead of sticking in "4", they can put in "2+2". Its easier than doing the math on some scratch pad on the side, helps the user remember how they arived at their conclusion, and easier to go back and edit later. Basically makes a calc field result like a spreadsheet.

You don't mean that it doesn't work with numbers do you Queue?

I use text color all the time in number fields.

Yeah, I've got to format the number field to a fixed number of decimal places, so that nixes the ability to add text color.

Well, you could use a formula such as the one displayed here to format your number in the calculation instead.