Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
What is the exact opposite of FirstSotedValue i.e some thing like LASTSortedValue?
Thx
C
The opposite is the firstsortedvalue too, only you put a - in front of the field/expression you want to sort on.
firstsortedvalue(Customer, Orderdate) gets the customer with the minumum orderdate
firstsortedvalue(Customer, -Orderdate) gets the customer with the maximum orderdate
The opposite is the firstsortedvalue too, only you put a - in front of the field/expression you want to sort on.
firstsortedvalue(Customer, Orderdate) gets the customer with the minumum orderdate
firstsortedvalue(Customer, -Orderdate) gets the customer with the maximum orderdate
use vlastsortedvalue