Repeat max Date for Same ID

[#1]

Hi All

I have this Requirement

For Better understanding, I have Attached sample qvw.

Regards

Cire

[swuehl · Accepted solution]

Try

=If(Year(Date1)=1900,FirstSortedValue(Total<ID> Date2, -Flag),Date1)

[sunny_talwar]

May be this:

IF(WildMatch(Date1,'*1900*'),FirstSortedValue(TOTAL <ID> Date2, -Flag),Date1)

[#4]

Thank You Both of You.

Great Learning for me.

Regards

Cire