AnsweredAssumed Answered

if Calculation Result is empty then move to next...

Question asked by JCPython on Apr 18, 2012
Latest reply on Apr 19, 2012 by JCPython

Title

if Calculation Result is empty then move to next...

Post

i have a table that keeps records of recorded wight and length of animals, i also have fields that calculate to get the last inputed record and display it in the fields Current Weight and Current Length, sometimes weight or sometimes length isnt always recorded together, so weight may have data in a record and length can be empty, but since its all in one record table then Current weight will be updated, but since the length was left empty on the last record, it will display the current length as empty, is their a way to perform a script that if field is empty then get calculated data from the next most recent record?

Outcomes