Hi. You might start with the Min() function.
Example, Min( 5; 3; 9; 7; 8 ) — yields 3
You might use it like this: Min( calcfield1; calcfield2; calcfield3 )
I'd suggest using the Let () function. It allows you to use the results of each test in later test.
Let ( [
result1 = Case ( A < B ; A ; B ) ;
result2 = Case ( C < result1 ; C ; result1 ) ] ;
Assuming this is being done in the Calculation Dialog, you can use the Min function to determine the minimum value. Example:
Min ( Subtotal ; DiscountTotal ; StandardAmt )
will return the smallest value among the three options. Note that this will work if the three fields are on the same record. (This would include calculation fields.)
Thanks all. I'll be madly reading up on these sections of the book tonight... to see if I can figure out how to accurately apply these suggestions to my d.base.
Keep 'em coming!
And thanks for the direction. I felt like I was swimming in mud here.