Calculate position in sort order
I'm trying to find a way to 'dynamically' calculate the position of a record in a sort order. I want to use the resultant number in a second calc.
I know that I can use RecordNumber, but it is not dynamic. In other words, yes I can use RecordNumber in a portal, where it is 'dynamic', but I can't use the result in a second calc.
I realise that I can fudge this with scripts, but am hoping that there might be a more elegant solution.