AnsweredAssumed Answered

Help with finding highest value with exceptions

Question asked by john.s on Oct 27, 2014
Latest reply on Oct 28, 2014 by john.s

Title

Help with finding highest value with exceptions

Post

I have a field "Pile Number" that get assigned to Photo Orders.  Once we have ten or eleven orders we assign the next higher pile number.  The problem I have is knowing how many orders are in the current pile and when to start with the next number.  To complicate the problem we have special orders that always get put in pile 99 so I can't just look up the highest value in the field.  Any thoughts on how I can let the user know how many orders are in the last assigned pile excluding pile 99?

Thanks,

John

 

 

Outcomes