Here’s something that just occurred to me… why don’t the Min() and Max() reporter functions take into account a custom sort?
Suppose you have status codes like Pre, During, and Post. Now with a custom sort you can define them in that order so that your report comes out looking like everyone expects it to look.
But if you want to know the “max” status that an item has obtained, and you do a Max() on an item that has been through Pre and is currently in During, your Max() will return Pre which is not correct.
It seems like the Max() should understand and acknowledge the custom sort, and the maximum of Pre and During should return During instead.
Doesn’t it make sense? Sounds like an enhancement request to me, if it hasn’t already been made…
How would you work around this issue, so that the Max() would return the proper value of “During”?
Dave Rathbun (BOB member since 2002-06-06)