Get last 2 records

Mon, 07 May 2012 10:30:15 GMT

Hello,

I have a table where i have to get the last 2 records where the amounthave changed:

can this be done without having to create a special table for this report from the script?

any suggestion?

Re: Get last 2 records

rwunderlich — Mon, 07 May 2012 22:44:29 GMT

How about:

=subfield(concat(DISTINCT Amount, ';', StartDate), ';', count(DISTINCT Amount))

for the last record.

=subfield(concat(DISTINCT Amount, ';', StartDate), ';', count(DISTINCT Amount)-1)

and the next to last record.

-Rob