Skip to Content
0
Former Member
Sep 14, 2007 at 08:32 PM

Writing a formula to populate a field

16 Views

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!!!!