First Sorted Value With Dates and Conditions

[Anonymous]

I have data that looks like

Person/CreatedDate/CloseDate/Won

Bob/(1/11/2011)/(1/12/2011)/1

For each person, I am trying to get the FIRST CLOSED DATE that is GREATER THAN OR EQUAL TO each individual's CREATE DATE.

What I have so far is below but it is not working. Any help is appreciated!

=FirstSortedValue({< Won = {'1'}, [Close Date]={">=Date(OppUserCreatedDate,'MM/DD/YYYY')"}>} [Close Date], [Close Date])

- dave

[sunny_talwar · Accepted solution]

Since each person can have a different CreatedDate... set analysis won't work here... may be use an if statement

Max({<Won = {'1'}>} If([Close Date] >= OppUserCreatedDate, [Close Date]))

[Anonymous]

Thank you