Hi all,'
I ahve to calulate the value for a fied "Handling Unit quantity" based on the foll formula:
No of handling Units = No of labels
No of labels calculated as follows: Item Quanity/Starp quantity
e,g, 5/3 = 1.67 (rounded to next no) i.e. "2".
Now No of Handling units for the above example would be 2.Hence Qty for handling Unit 1 would 2 and handling Unit 2 would be "3".
Similarly if no oflabels is calculated as follows:
e.g. 10/3 = 3.33 (rounded to next no) so "4".
So # of handlng units will be 4 and ratio for the quanityies would be 3:3:3:1.
However im not able to develop a logic so tha I can obtain the quanities for each of the handling units.can someone help me ?
Thanks.