AnsweredAssumed Answered

Max text calculation

Question asked by MikeEdwards on Jul 11, 2011
Latest reply on Jul 12, 2011 by MikeEdwards


Max text calculation


I have ten fields for 10 possible part numbers. I want to display the first part # and have a field to determine the last part number on the page. I used to do this with a Max calculation but now the part numbers have text and can vary in numeric value. I was trying to figure out what calculation to use to display the last part entered on the page. If field 10 is empty then field 9, if field 9 is empty then field 8 and so on.