I need to be able to create a Field that flags either yes or no based on a particular set of criteria. Please see mock table below.
|RefNoType||RefSeq||Claim Type State||Claim Type State Done Date||Claim Type State Id Changed Flag|
I am trying to create the field highlighted with the red writing.
I need to distinguish when the last RefSeq of a particular RefNoType is either Closed or ReClosed when this is true to show 'Yes'
if it is notified or Reopened or if the there is another RefSeQ after it was CLosed or Reclosed then it should show 'No'
I would appreciate any help.
Thanks in advance