Skip to Content
0
Feb 02, 2010 at 04:15 PM

How to pick the lower value among the Four amount fields

39 Views

Hi Experts,

I have four amount fields like following:

Amt1

Amt2

Amt3

Amt4

Now I have show the output with lower value among the aboe four.

i.e. Mininmum of Amt1 Amt2 Amt3 Amt4.

Ex: If,

Amt1 = 22.00

Amt2 = 451.00

Amt3 = 11.00

Amt4 = 126.00

The output should be Amt3 i.e 11.00.

I don't want to use LE, LT..kind of operaters.

Please let me know if there is any keyt word or short method for this.

Thanks

Naveen Inuganti