Unable to resolve #Multivalue problem

[Former Member]

I have thousands of records. A sample table is as below

Job ID     Task ID      Task Name     Task Start Date     Task End Date

A               A1              One               28-Apr-2008          28-May-2009

B               A2              Two               #MULTIVALUE     #MULTIVALUE

C               A10            Ten               30-Jan-2013          30 Dec-2014

I have created a measure using Max for both Task Start Date and Task End Date. Encountered #MULTIVALUE error for some records. I have tried playing around with the table properties and it doesn't work.

Should a If Else statement be used?  How do I go about it?

It seems like WEBI could not differentiate that there could be other Task ID and/or Task Name with the same Task Start/End Date, though each Job ID will not have two exact Task ID and Task Name.

Thank you.

[Former Member]

Hi Dan,

Try using  formula

=Max(date) in(Task ID)

If it doesn't work try replacing Task ID with  Job Id or Task Name

Regards

Supriya

[Former Member]

Sorry, what other methods of aggregation to use since the #MULTIVALUE error happens on a date and not a like a whole amount eg revenue.

I just use a simple = Max ([Task Planned Start Date]).

[kohesco]

Hi,

Last ([Task Planned Start Date]) will definitily results in one date.

Greetings

Koen

[former_member210032]

Hi Dan,

This link will help you

Regards

Mustafa

[Former Member]

Hi Dan,

Could you please share the formula which you have created for Task Start Date and Task End date?

Regards,

Yuvraj