Show the Last Value from Field in a Table

[#1]

Hello!

I have a Simple Table with:

• ACCOUNT_ID
• INSPECTION_DATE
• AMOUNT

1 Account_Id could have 2 Inspection_Date.

What I want is to show in this Simple Table the last Inspection_Date for the Account_id.

Do you know how could I do that?

Thank you!!!

[its_anandrjs]

Hi Manish,

Yes it is right by AMOUNT the date is not obtain because in data the amount should be same then it is not worked, thanks for identify.

Regards

[its_anandrjs]

Hi Eduardo,

By AMOUNT in firstsortedvalue is not good enough i change the script and use Max and Min because in data the amount should be same in some condition then not worked Max and Min should be the right one. I wanted to do it with the Max and Min but suddenly use Firstsortedvalue. For Amount it is correct FirstSortedValue(INSPECTION_DATE, AMOUNT).

Regards

Anand