Aggregated set analysis

[#1]

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

[#2]

Hello,

I do not how you did your data model , but try to add an aggregate by both Claim Number and Claimant type .

Regards,

Beyrem