EXPRESSION PROBLEM

[rohitians]

Hello,

if(ISNULL(PROD_GROUP_NAME) OR LEN(PROD_GROUP_NAME)=0,1,0) AS IsMissingProductGrp,

      if(ISNULL(THERAPEUTIC_NAME ) OR LEN(THERAPEUTIC_NAME )=0,1,0  ) AS IsMissingProductTherapy,

In the above two expressions i want to add one condition in the first one is if PROD_ID=0 then i need IsMissingProductGrp as 1

add  if THERAPEUTIC_NAME=OTHERS then i need  IsmissingProductTherapy as 1,

Thanks and Regards,

Rohit

[kaushiknsolanki · Accepted solution]

Hi,

     Try this.

     if(PROD_ID = 0,1,

      if(ISNULL(PROD_GROUP_NAME) OR LEN(PROD_GROUP_NAME)=0,1,0)) AS IsMissingProductGrp,

     and

     If(THERAPEUTIC_NAME = 'OTHERS',1,

if(ISNULL(THERAPEUTIC_NAME ) OR LEN(THERAPEUTIC_NAME )=0,1,0  )) AS IsMissingProductTherapy

Regards,

Kaushik Solanki

[rohitians]

It was small but I am learning thanks for your support...

.