I have rate for every PO depends on its weight. We have column for weight bracket if it falls under weight bracket I need to pickup that rate.
in Below example this PO 4859554638 has weight 1070 lb it falls in weight bracket 999 it should pickup only $25.86
in 2nd PO 4859606472 has weight 546 lb it falls in weight bracket 499 then it should pickup $26.43
CUSTOMER PO_NUM PO_WGT Wgt_Brackets RatePerKg 3009848B28 4859554638 1070 499 $29.74 3009848B28 4859554638 1070 999 $25.86 3009848B28 4859554638 1070 1999 $22.31 3009848B28 4859554638 1070 4999 $21.30 3009848B28 4859554638 1070 9999 $12.15 3009848B28 4859554638 1070 19999 $8.86 3009848B28 4859554638 1070 29999 $6.88 3009848B28 4859554638 1070 39999 $5.40 3009848B28 4859554638 1070 999999 $4.59 3402427A28 4859606472 546 499 $26.43 3402427A28 4859606472 546 999 $17.24 3402427A28 4859606472 546 1999 $11.90 3402427A28 4859606472 546 4999 $10.14 3402427A28 4859606472 546 9999 $8.86 3402427A28 4859606472 546 19999 $8.44 3402427A28 4859606472 546 29999 $7.63 3402427A28 4859606472 546 39999 $7.52 3402427A28 4859606472 546 999999 $6.37
I need my result in 3 column summary
Customer PO_num RatePerkg
3009848B28 4859554638 $25.86
3402427A28 4859606472 $26.43
I need to use iif condition if PO_wgt>Weight bracket then rate
thanks in advance. your help is appreciated.