Write an expression with multiple conditions

[gilldilpreet]

Hi, 

I am trying to write the expression below but it is returning an error.

I would like the calculated dimension to show the Acceptance date WHERE the Paper Type Code =1 and for the highest Paper Number (which is a field that shows paper numbers in sequence i.e. identifies the most recent).

Thanks in advance for any help on this! 

Dilpreet 

[Kushal_Chawda]

@gilldilpreet Can you share sample data with expected output?

[gilldilpreet]

Using the data below as an example;

Student ID	Paper Type Code	Paper Number	Acceptance Date
1	1	A01	02/03/2004
1	1	A02	03/03/2004
1	2	A03	04/03/2004
2	1	A05	05/03/2004
2	2	A06	06/03/2004

This is the result I am after;

Student ID	Acceptance Date
1	02/03/2004
2	05/03/2004

[Brett_Bleess]

@Kushal_Chawda  Poster responded back with sample data and expected output, guessing the notifications may still be having some issues in Community, sorry about that if so.  Thanks in advance for checking back.

Regards,
Brett

[Kushal_Chawda]

@gilldilpreet  try below expression

=aggr(if([Paper Number]= maxstring(total <[Student ID]>{<[Paper Type Code]={1}>}[Paper Number]),[Acceptance Date]),[Student ID],[Paper Type Code],[Paper Number])