I am trying to create a calculated field where the data returned is the sum of data lines for the same field and is dependent on the value in 2 other fields. I want to return the sum of the MTDHRS_1 field if the year = (specific year) and the pyrlrtyp = 1 (or Pay Codes) I can’t seem to get the syntax correct. Can I have 2 CASE fields in the same calculated field? Thanks
If you would like to submit an answer or comment, please sign in to the eOne portal.