Post Author: robertr
CA Forum: General
Hi - I have a report that includes a "STATUS" field. I would like to know if there is a way to add an additional value to the STATUS field that is NOT generated by the report? For example, the "STATUS field only populates either Active or LOA but not Terminated. I need the STATUS field to look at a field called ACTUAL TERMINATION DATE and populate the value "TERMINATED" within the STATUS field if there is a DATE value wthin the ACTUAL TERMINATION DATE field. This way I can include the reason TERMINATED for all employees that have a termination date. Please help!!!!