Calculation Field Help Needed 1

[otakar]

I have a Calculation field "A" which is already a SUM of several number fields. I would like to compare the field "A" with another field "B". And if field "A" is smaller then field "B", I would like to have the number in field "A" display in RED. If "A" is larger than "B" then it needs to be in GREEN color.
How would you write such a calculation, please ? And how to add it to the existing SUM calculation ?
Thank you in advance from a "newbie" !

 

[CryoGen]

Try this:

Case (

field_a ? field_b; field_a;
field_a < field_b; TextColor ( field_a; RGB ( 255; 0; 0 ) )

)

 

[CryoGen]

Sorry, didn't read your post completely. Try this instead ...

Call this calculation field "c_field_a" and

Case (

Sum ( numb_field1;numb_field2;numb_field3 ) ? field_b; TextColor ( Sum ( numb_field1;numb_field2;numb_field3 ); RGB ( 0; 255; 0) );
Sum ( numb_field1;numb_field2;numb_field3 ) < field_b; TextColor ( Sum ( numb_field1;numb_field2;numb_field3 ); RGB ( 255; 0; 0) )

)

 

[CryoGen]

Apparently I can't get out of my own way tonight ... one more time from the top ...

Case (

Sum ( numb_field1;numb_field2;numb_field3 ) = field_b; Sum ( numb_field1;numb_field2;numb_field3 );

Sum ( numb_field1;numb_field2;numb_field3 ) > field_b; TextColor ( Sum ( numb_field1;numb_field2;numb_field3 ); RGB ( 0; 255; 0) );

Sum ( numb_field1;numb_field2;numb_field3 ) < field_b; TextColor ( Sum ( numb_field1;numb_field2;numb_field3 ); RGB ( 255; 0; 0) )

)

This assumes that you want the color to be the default black if the values in field a and field b are the same.

You could also avoid typing those annoying sum fields over and over again by using the Let function.