I was wondering if anyone knows how to compare data within a portal. For example, I need to compare a numeric figure from the most current row in the portal to the previous row. If the number increases I need to prompt the user with a message. Any input would be greatly appreciated.

Thanks!!

Previous row is a deceptive term since it depends upon the sort order of the relationship.

I suppose a script could be made that goes to the current related record (show only related records) then sorts appropriately, goes to the previous record and does the check.

It'd have to be scripted because I don't know of a calculation that will do the job. Other people may know!

Probably best with a script.

Set a global to the value of the current portal item, step back a row, and compare the now current portal row item with the global - decide from there.