topic Re: If statement Error(Missing right parenthesis) in App Development

If statement Error(Missing right parenthesis)

karthik_nataraj — Wed, 04 Nov 2020 04:40:51 GMT

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.

Re: If statement Error(Missing right parenthesis)

Vegar — Wed, 04 Nov 2020 05:41:07 GMT

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() ))

Re: If statement Error(Missing right parenthesis)

karthik_nataraj — Wed, 04 Nov 2020 07:34:22 GMT

Hi!

Thanks for the reply,

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

Re: If statement Error(Missing right parenthesis)

MayilVahanan — Wed, 04 Nov 2020 09:03:27 GMT

HI @karthik_nataraj

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

Re: If statement Error(Missing right parenthesis)

karthik_nataraj — Wed, 04 Nov 2020 09:09:28 GMT

Hi Mahil,

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

Re: If statement Error(Missing right parenthesis)

QFabian — Wed, 04 Nov 2020 13:57:39 GMT

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()))

Re: If statement Error(Missing right parenthesis)

karthik_nataraj — Thu, 05 Nov 2020 04:47:43 GMT

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.