Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have a straight table with
ID Orderno endDate
1 1 1/10/2015
1 2 3/10/2015
I want to display this in straight table like below with max date
ID Orderno endDate
1 1 3/10/2015
1 2 3/10/2015
Can you please help me with this logic.
Thanks
karthik
Hi,
In the expression, you can use Max(Total [End Date]):
Hope this helps.
Hi Sinan,
Thanks for that , it work if we have only 1 id, but if we have multiple ids it does not work
Say
ID Orderno enddate
1 1 1/10/2015
1 2 3/10/2015
2 1 10/10/2015
3 1 11/10/2015
i want the straight table like below
ID Orderno enddate
1 1 3/10/2015
1 2 3/10/2015
2 1 10/10/2015
3 1 11/10/2015
Thanks
Karthik
Try
=max(TOTAL <ID>enddate)
I am not at my computer, but try this Aggr(Max(Enddate), ID)
Thanks
Hi Settu,
Thanks a lot this logic.. it works , but can we do like this if i have selected the max date and need to display its order no in the same field.
For example:
ID Orderno enddate
1 2 1/10/2015
1 1 3/10/2015
2 1 10/10/2015
3 4 11/10/2015
3 2 23/10/2015
i want the data like below
ID Orderno enddate final_orderno
1 2 1/10/2015 1
1 1 3/10/2015 1
2 1 10/10/2015 1
3 4 11/10/2015 2
3 2 23/10/2015 2
Thanks in advance
Regards
Karthik
Hi Karthik,
sorry, I didn't get you. What based the "final_orderno" should get arrived?
HI Settu,
based on max(date), we need to get its order no and should populate for each row where the id is same
Thanks
Karthik
Hi Karthik,
Try this
=if(isnull(if(enddate=Max(TOTAL <ID>enddate),Orderno)),Above(Orderno),if(enddate=Max(TOTAL <ID>enddate),Orderno))
Note: I'm trying to simplify this