Skip to Content
0
Former Member
Aug 12, 2013 at 07:40 AM

Max effective start Date

46 Views

I have a requirement to display the empl class for each candidate based on latest start date in webi

For Example :

Candidate ID Start Date EmplClass
1111 3/15/2012 Contractor
1111 6/3/2013 Lcl Empl

Expected Result:
Candidate ID Start Date EmplClass
1111 6/3/2013 Lcl Empl

I have created a new variable to capture latest start date.

Formula: Max Start Date (Measure) =Max([Start Date]) ForEach([Candidate ID])

Then Retrieving the empl class based on latest start date

Formula: Empl Class =If( [Start Date] = [Max Start Date]) Then Empl Class

Current Result:
Candidate ID Max Start Date EmplClass
1111 6/3/2013 #MULTIVALUE

This gives me Multivalue error. Would appreciate any suggestions/Help ASAP. Thanks!