Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
=Aggr(Only({$<[Claimant State]={'Closed'}[Is Latest Ref Seq]=>}[Claim Transaction Done Date]),[Claimant Number])
This is my Formula which works fine however the formula only shows details that I need when Claimant State = Closed I also need it to show the details when claimant state = Reclosed. I tried The following
=Aggr(Only({$<[Claimant State]={'Closed'},[Claimant State]={'ReClosed'}, [Is Latest Ref Seq]=>}[Claim Transaction Done Date]),[Claimant Number])
This doesn't quite work as I believe what I have done is told it to only show what I want if = Closed and Reclosed were I need it to be an OR.
Hope this makes sense
Thanks for any response in advance
Try:
[Claimant State]={'Closed','ReClosed'}
Regards,
Gordon
That is Perfect thanks.