AnsweredAssumed Answered

Calculation Count with Multiple Fields

Question asked by csuwarrior88 on Nov 14, 2017
Latest reply on Nov 14, 2017 by user19752

I have student profiles that show a students employment history. I am trying to get a count of certain type of appointments during certain terms, for example TA appointments for Fall and Spring Terms only

 

I have created calculations that will generate TERM codes and Appointment Codes. I am trying to get a count of

 

Case (

TA_Total_TERMS_Code = "30" ; TA_Total_TERMS_Code = "10" ; "1" )

 

Case (

Funding Plan = "TA" ; "1" ; Funding Plan = "TA / GSR" ; "1" ; Funding Plan = "TA / Fellowship" ; "1" )

 

I want to get a count from of students TA appointments during only Term Code "30" and "10". How can I create a count calculation using these two case fields?

Attachments

Outcomes