AnsweredAssumed Answered

Let Statement Limit

Question asked by TracyKeenan on Apr 2, 2011
Latest reply on Apr 4, 2011 by philmodjunk

Title

Let Statement Limit

Post

A member of this forum helped me with the following:

Let ( [ PrevRank = GetNthRecord ( Rank ; If ( Get ( RecordNumber ) = 1 ; 0 ; Get ( RecordNumber ) - 1 ) ) ;          PrevScore = GetNthRecord ( Total Points; If ( Get ( RecordNumber ) = 1 ; 0 ; Get ( RecordNumber ) - 1 )  ) ] ;          If ( PrevScore ≠ Total Points ; Get ( RecordNumber ) ; PrevRank )      )

This calculates the rank of tennis players.

However, the let statement quits at the rank of 121 with the remaining records showing a ?

Is there a limit?  It works amazingly well for the players with a rank of 121 or less.

Thanks for your help.

Tracy

Picture_1.png

Outcomes