Returning a value of the max number in a table

[dimitrisch]

I have a table with purchase data.

Now I only want to return the latest purchase price in a pivot table.

I made this function:

If((max(purchasenumber)= purchasenumber),purchase.purchaseprice_netto)

--> purchasenumber is the unique number of the purchasedocuments, so the highest number (max) is the latest document.

I get a "-" as result in my pivot table, when I select the latest purchasedocument in a selection box than it returns the correct value!

What am I doing wrong?

[tresesco · Accepted solution]

Try using FirstSortedValue(), like:

FirstSortedValue(purchase.purchaseprice_netto, -purchasenumber)

[dimitrisch]

Thx, this gives the correct value!