AnsweredAssumed Answered

Go to first field in a found set with a non blank record

Question asked by Stu412 on Apr 25, 2017
Latest reply on Apr 25, 2017 by beverly

Hi there


I have a found set of around 20 records following a complex find.  I'm gathering variables on high and low values in the field 'Money'.  I've also got another field called 'MoneyAdj' which is a Case statement based on 'Money'.  As a result, around 6 of the found set in this field 'MoneyAdj' are empty values, which is correct.


However, from the 14 remaining, I need to show the lowest.  Easy right?  Just sort the found set ascending by 'MoneyAdj' and Go To Record [First].  Nope.  The blank rows come first, so my plan is scuppered here.


Is there any way of getting to the first non blank record in the 'MoneyAdj' field (which is the lowest actual value) without having to redo the find and omit routine I've already done to get to this stage?


I was thinking something like Go To Record by calc GetNthRecord (NotIsEmpty(MoneyAdj) but haven't had that working so far.


This is being done in a looping routine in a script and I'd like to keep that as light as possible.


Hope that makes sense!


Thanks in advance