Using two Arguments in Set Analysis

[#1]

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

[#2 · Accepted solution]

Try:

[Claimant State]={'Closed','ReClosed'}

Regards,

Gordon

[#3]

That is Perfect thanks.