1 of 1 people found this helpful
IF [ISPSRASSIGNED] // this assumes ISPSRASSIGNED is a Boolean field. If it's string, then do [ISPSRASSIGNED] = 'TRUE'
IF NOT ISNULL([PSR_SYC3]) // if this is not null then it's the last one populated
THEN [PSR_SYC3] ELSE
IF NOT ISNULL([PSR_SYC2]) // If we dropped to here then  was null. if this is not null then it's the last one populated
THEN [PSR_SYC2] ELSE
[PSR_SYC1] // If we dropped to here then  and  were null, and this assumes that  is populated
You may need to clean up some syntax, but that's the gist of one way to do this.
Thank you very much for your contribution!