Hi
I am trying to create a Notifiaction date please see table below using the following code. The problem I have as you can see in the table is that Mrs P Ball has 2 instances of notified 1 with a claimant type of TP 1 with a claimant type of PI. For some rerason my code does not like this and returns nothing for Mrs P Ball.
Has anyone any ideas on how I can correct this
=Aggr(Only({$<[Claimant State]={'Notified'},[Is Latest Ref Seq]=>}[Claim Transaction Done Date]),[Claimant Number])
| Claim Number | Claimant Type | Claimant Contact Name | Claimant Notification Date | Claimant State |
| | | | |
| RS100202 | AD | Doctor Richard Norman Michael Stitson | 22/02/2011 15:53:16 | Notified |
| RS100202 | PI | Master G Ball | 08/03/2011 12:08:18 | Notified |
| RS100202 | PI | Mr D Ball | 22/02/2011 15:53:16 | Notified |
| RS100202 | PI | Mrs P Ball | - | Notified |
| RS100202 | TP | Mrs P Ball | - | Notified |
Regards
