Calculated Dimension in Script

[cbaqir]

This works as a calculated dimension but I can't get it to work in the script. It says Error: Error in expression:
 ')' expected. Any idea why?

if((subfield(GOV_DECISION_BODY,';')=PRIMARY_DECISION_BODY,date#(yearstart(PRIMARY_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=PRIMARY_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(PRIMARY_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=SECONDARY_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SECONDARY_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=SECONDARY_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SECONDARY_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=THIRD_DECISION_BODY,date#(yearstart(THIRD_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=THIRD_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(THIRD_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=FOURTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FOURTH_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=FOURTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FOURTH_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=FIFTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FIFTH_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=FIFTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FIFTH_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=SIXTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SIXTH_DECISION_AGENDA_DATE))
,if((subfield(GOV_DECISION_BODY,';')=SIXTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SIXTH_DECISION_AGENDA_DATE
)))))))))))))))))))))))))) as AGENDA_DATE_YEAR,

[Frank_Hartmann · Accepted solution]

Maybe this:

if(subfield(GOV_DECISION_BODY,';')=PRIMARY_DECISION_BODY,date#(yearstart(PRIMARY_DECISION_AGENDA_DATE))
,if(subfield(GOV_DECISION_BODY,';')=PRIMARY_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(PRIMARY_DECISION_AGENDA_DATE))
,if(subfield(GOV_DECISION_BODY,';')=SECONDARY_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SECONDARY_DECISION_AGENDA_DATE))
,if(subfield(GOV_DECISION_BODY,';')=SECONDARY_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SECONDARY_DECISION_AGENDA_DATE))
,if(subfield(GOV_DECISION_BODY,';')=THIRD_DECISION_BODY,date#(yearstart(THIRD_DECISION_AGENDA_DATE))
,if(subfield(GOV_DECISION_BODY,';')=THIRD_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(THIRD_DECISION_AGENDA_DATE))
,if(subfield(GOV_DECISION_BODY,';')=FOURTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FOURTH_DECISION_AGENDA_DATE))
,if(subfield(GOV_DECISION_BODY,';')=FOURTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FOURTH_DECISION_AGENDA_DATE))
,if(subfield(GOV_DECISION_BODY,';')=FIFTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FIFTH_DECISION_AGENDA_DATE))
,if(subfield(GOV_DECISION_BODY,';')=FIFTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(FIFTH_DECISION_AGENDA_DATE))
,if(subfield(GOV_DECISION_BODY,';')=SIXTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SIXTH_DECISION_AGENDA_DATE))
,if(subfield(GOV_DECISION_BODY,';')=SIXTH_DECISION_BODY_COMMITTEE_CAT,date#(yearstart(SIXTH_DECISION_AGENDA_DATE
)))))))))))))) as AGENDA_DATE_YEAR,

[Or]

Try removing the double parenthesis from each line (and the matching ones at the end). You don't need two, and the script engine doesn't seem to like it.