Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@gilldilpreet Can you share sample data with expected output?
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 |
@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
@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])