blackorchids2002
Board Regular
- Joined
- Dec 29, 2011
- Messages
- 138
Hi Masters, just to make it understandable please see below.
AWB #7082013260 has 3 records. Each 3 records for the same way bill number has different actual weight and dimensional weights. To get the billable weight, I used the formula MAX to get the maximum weight between actual weight and dimensional weight.
In the example, you will see the billable weight for each record but I want the billable weight to be shown as one input.
<tbody>
</tbody>
The output would be as per below. Kindly note that the records are not sorted out so it may be placed into different lines/rows in the excel sheet.
<tbody>
</tbody>
Thanks
<tbody>
</tbody>
AWB #7082013260 has 3 records. Each 3 records for the same way bill number has different actual weight and dimensional weights. To get the billable weight, I used the formula MAX to get the maximum weight between actual weight and dimensional weight.
In the example, you will see the billable weight for each record but I want the billable weight to be shown as one input.
AWB# | ACTUAL WEIGHT | DIMENSIONAL WEIGHT | BILLABLE WEIGHT |
7082013260 | 875 | 800 | 875 |
7082013260 | 781 | 800 | 800 |
7082013260 | 850 | 800 | 850 |
<tbody>
</tbody>
The output would be as per below. Kindly note that the records are not sorted out so it may be placed into different lines/rows in the excel sheet.
AWB # | ACTUAL WEIGHT | DIMENSIONAL WEIGHT | BILLABLE WEIGHT |
7082013260 | 875 | 800 | 2,525 |
7082013260 | 781 | 800 | |
7082013260 | 850 | 800 |
<tbody>
</tbody>
Thanks
<tbody>
</tbody>