4 Replies Latest reply on Sep 8, 2011 11:34 AM by GFS

    Calculate position in sort order

    GFS

      Title

      Calculate position in sort order

      Post

      Hi,

      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.

      Any suggestions?

      Grant