DerivationStatement

[scorpion]

Hi,

I have 2 source fields:

AAA,
BBB

my target field name is:

XXX

The logic to populate XXX target column like below:

if AAA = 255 ( BBB<0 THEN populate XXX= LOSS,but IF BBB >0 then populate XXX=PROFIT)

Else other than AAA=255 VALUES leave it blank.


Can any one help me to apply this in IF-THEN-ELSE statements.

[meena]

If (AAA = 255 & BBB<0) Then 'LOSS' Else If (AAA = 255 & BBB >0) then 'PROFIT' Else ' '

AAA,
BBB

my target field name is:

XXX

The logic to populate XXX target column like below:

if AAA = 255 ( BBB<0 THEN populate XXX= LOSS,but IF BBB >0 then populate XXX=PROFIT)

Else other than AAA=255 VALUES leave it blank.

[ray.wurlod]

Code: Select all

If AAA = 255 Then If BBB > 0 Then "PROFIT" Else If BBB < 0 Then "LOSS" Else "" Else ""

may be slightly more efficient

[scorpion]

Thanks Ray...