expression problem

[adiarnon]

callid	date	description
1	1.1.14	a
2	2.1.14	b
2	5.1.14	c

i want to get this table

callid	last des
1	a
2	c

i want to get the latest description (by date).

what should i put in the last des expression?es

[#2]

Hi

max(aggr(description, date)

beware date has to be under date format

best regards

chris

[#3]

You can use the expression

MaxString(description)

[jerem1234]

Should be able to use firstsortedvalue(). Something like:

firstsortedvalue(description, -date)

Hope this helps!

[jagannalla · Accepted solution]

Adi Arnon,

Just load your data, make sure your date column is loading according to your system format.

In st. table: Dim as Callid and Exp as =FirstSortedValue(description,-date)

Thanks,

Jagan

[adiarnon]

hi,

its not working =\

what do you mean by date format?

[PrashantSangle]

Hi,

use this expression

MaxString(Aggr(description,date))