Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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() ))
Hi!
Thanks for the reply,
I tried the above code, but it is giving 'Incomplete visualization' Error
Instead of & symbol, please use the "AND" word .
Hi Mahil,
If I use "AND" I am getting 'Missing right parenthesis error'
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()))
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.