Hey Anuj,

Try this:

IF "Status" = Include All AND Field 1 = "value x" AND Field 2 = "value y" AND Field 3 = "value z"

     THEN

     1

ELSEIF "Status" = Include None AND Field 10 = "value PQRST" AND Field 20 = "value XYZ" AND Field 30 = "value ABCD"

     THEN

     1

END

Cheers,

Matthias

Hi Anuj

Not exactly sure, but something like this?

[Calculation1]

IF [Status] = "Include All"

THEN

(if [Set Field]="Field 1" then "value x"

elseif [Set Field]="Field 2" then "value y"

elseif [Set Field]="Field 3" then "value z" end)

ELSE

(if [Set Field]="Field 10" then "value PQRST"

elseif [Set Field]="Field 20" then "value XYZ"

elseif [Set Field]="Field 30" then"value ABCD" end)

END

Thanks,

Shin