Calculation Definition

[mhemans]

I am looking to create a calculation with a result that is based on 2 different text fields. For example: field one contains "Blue" and field two contains "Red", I want to show a result of "purple".

Any suggestions?

[Fitch]

Case(

field one = "Blue" and field two = "Red", "purple",

field one = "Yellow" and field two = "Blue", "green" )

[mhemans]

Anything special to add 3 fields and one result?

[-Queue-]

What do you mean?

[mhemans]

for example: field 1 = blue, Field 2 = red, Field 3 = pink with a result of dark purple

[-Queue-]

Case(

field one = "blue" and field two = "red" and field three = "pink", "dark purple" )