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