You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

how to loop through person's work relationship from current to oldest in fast formula

edited Jan 30, 2020 12:05AM in Human Capital Management 1 comment

Content

I am trying to read a person's work relationship from current to oldest in a fast formula. Following is an example:

Rel1- 9/24/15 to 3/29/18  Terminated 

Rel2- 3/30/18 to 1/12/2020   Terminated

Rel3 1/13/2020 to preset. Active

I am trying to use below

count =1

WHILE (PER_EXT_WORK_REL_DATE_START.EXISTS(count)) LOOP

The problem is it works for some people and for some it fails totally. what is the ideal way to traversing employee's historical work relationships

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!