create a loop formula

[gjack72]

I need to be able to make a for loop that will run thru my records until it finds the first number > 0.

Here is what I have as of now. This works but it only looks at the first record, so if it is a 0 or null it will look at my next record and then stop. Sometimes the 2nd record is null or a 0 so I need it to continue looking until it finds a number > 0.
Thanks,

GJ


If {MagicLoanAndCBScoreQuery.CB_REPORT_TIMESTAMP} >= {MagicLoanAndCBScoreQuery.CB_REPORT_TIMESTAMP}
and IsNull({MagicLoanAndCBScoreQuery.CBSCORE}) OR ({MagicLoanAndCBScoreQuery.CBSCORE} = 0) then
Next({MagicLoanAndCBScoreQuery.CBSCORE})
else
{MagicLoanAndCBScoreQuery.CBSCORE}