If statement Error(Missing right parenthesis)

[karthik_nataraj]

Hello All!

I am creating a calculated field using the below if statement to create additional column in my file

if((OPSN_PLANNED_QUANTITY=1 and OPSN_COMPLETED_QUANTITY=0 and OPSN_REJECTED_QUANTITY=0 and OPSD_PLANNED_START_DATE and OPSD_PLANNED_CLOSED_DATE and OPSD_START_DATE),
 'Operation Active',
   
 if((OPSN_PLANNED_QUANTITY=1 and OPSN_COMPLETED_QUANTITY=0 and OPSN_REJECTED_QUANTITY=0 and OPSD_PLANNED_START_DATE and OPSD_PLANNED_CLOSED_DATE),
     'Operation Planned',

when I use single condition the function is working, but as i added one more condition to it, there is error:

Missing right parenthesis.

[Vegar]

You are missing right parentheses. Try this :

IF( (OPSN_PLANNED_QUANTITY=1 and OPSN_COMPLETED_QUANTITY=0 and OPSN_REJECTED_QUANTITY=0 and OPSD_PLANNED_START_DATE and OPSD_PLANNED_CLOSED_DATE and OPSD_START_DATE),

 'Operation Active',

 IF( (OPSN_PLANNED_QUANTITY=1 and OPSN_COMPLETED_QUANTITY=0 and OPSN_REJECTED_QUANTITY=0 and OPSD_PLANNED_START_DATE and OPSD_PLANNED_CLOSED_DATE),

     'Operation Planned',

Null() )) 

[karthik_nataraj]

Hi!

Thanks for the reply,

I tried the above code, but it is giving 'Incomplete visualization' Error

[MayilVahanan]

HI @karthik_nataraj 

Instead of & symbol, please use the "AND" word .

[karthik_nataraj]

Hi Mahil,

If I use "AND" I am getting 'Missing right parenthesis error'

[QFabian]

Hi, i just took off  a couple of parenthesis and works fine : 

---

Load
IF(
OPSN_PLANNED_QUANTITY=1 and
OPSN_COMPLETED_QUANTITY=0 and
OPSN_REJECTED_QUANTITY=0 and
OPSD_PLANNED_START_DATE and
OPSD_PLANNED_CLOSED_DATE and
OPSD_START_DATE,

'Operation Active',

IF( OPSN_PLANNED_QUANTITY=1 and
OPSN_COMPLETED_QUANTITY=0 and
OPSN_REJECTED_QUANTITY=0 and
OPSD_PLANNED_START_DATE and
OPSD_PLANNED_CLOSED_DATE,

'Operation Planned',

Null()))

[karthik_nataraj]

Hello!

I tried the above if statement,

It is working fine for Add expression in analyze sheet but if I do the same in the table as Add calculated field it is giving an error.

Attached the screenshot for the same.