I want a state such that when FACULTY MEMBER = no, then FISCAL YEAR won't be needed (It will be in OFF state). I have used N/A as a solution but this also means that N/A is an option and thus the PICT tool will give me more results. How do I do something like, IF FACULTY MEMBER = NO, THEN IGNORE FISCAL YEAR?
FACULTY MEMBER: yes, no
FISCAL YEAR: 9, 10, 11, FISCAL YEAR, N/A
IF [FACULTY MEMBER] = "NO" THEN [FISCAL YEAR] = "N/A";
IF [FACULTY MEMBER] = "YES" THEN [FISCAL YEAR] <> "N/A";
Aucun commentaire:
Enregistrer un commentaire