Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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,
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,
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.