Skip to Content
0
Jul 27, 2016 at 09:10 AM

#Multivalue issue while capturing max values after comparison

488 Views

Hi All,

I am getting following error while capturing max values in webi report.

Data is look like in below screenshot :

I need to Show Max(Cert end date) for Max(Cert Pgm Yr) among all the values of Cert Pgm Yr and Cert Category="Skill Area 04 - Chassis" else display Cert End date

and Output Report will contain only Student Id, Cert Category ,Cert Level and calculated Values.Below output i require.

I have applied some formula but it is giving me #Multivalue error and i can;t hide the column as it is BO 3.1.

=If([Max Program Year] ForEach ([Cert Pgm Yr])= [Cert Pgm Yr] And [Cert Category]="Skill Area 04 - Chassis";Max([Cert End Date]);[Cert End Date])

Please suggest me the proper solution and let me know if you guys require any more info.

Thanks,

Anish

Attachments

Data.JPG (63.1 kB)
Output.JPG (36.4 kB)