I have an FB file of length 80 that has a key field, a value field and a multiple field. I need to sort the file in the order of the lowest unit value field record. Unit value is the value field divided by the multiple.
Key field - numeric 10 bytes
Value field - numeric 15 bytes
Multiple feild - numeric 5 bytes
When i am doing this, i am facing issues with rounding down in the division operation. Value 100 with a multiple of 3 and value 101 with a multiple of 3 both give 33 as output, although i want the sorted order to have 100 with value 3 to come first.