Expression help

[abhaysingh]

i have to show Active or Inactive Customers

For Active customers1 the Flag is null value and

for inactive customer1 the flag is '01'

For Active customers2 the Flag is null value and

for inactive customer2 the flag is '01'

For Active customers3 the Flag is null value and

for inactive customer3 the flag is '01'

For Active customers4 the Flag is null value and

for inactive customer4 the flag in 'X'

pls help to write the expression??

[sujeetsingh]

Something like this will do

if(Active customers=1 and Flag =null() and

inactive customer=1 ,1,

if(Active customers=2 and Flag =null() and

inactive customer=2 , 1)) as flag

[Anonymous]

Hi,

Try with this:

if(flag=null(),'Active Customer',if(flag='01' or flag='X','Inactive Customer') as typeofCustomer.