Is it possible ?

[Shadowizoo]

Hi, I have 3 calculation field called a, b and c.

Is it possible to set, for example, the b field to '2' and the c field to '3' IF the a field worth '1' ?

I'd like to do it without a script.

Thx

Edited January 13, 2009 by Guest

[bcooney]

Yes.

field_b = If ( field_a=1; 2; "")

field_c = If ( field_a = 1; 3; "")

[Shadowizoo]

Excuse me, but i forgot to add informations.

Actually I'm in the "Specify Calculation" menu for the field_a. So I need to write the calculation result...field_a = "Need to write something".

What i would like to do is to set field_b and field_c to something into the "Need to write something" formula. Can I ?

[bcooney]

I don't understand. Rather than fieldA, please describe what you're trying to achieve using real data examples.