Skip to Content
Former Member
Nov 30, 2016 at 12:45 PM

Different Units of Measure for the same product

50 Views Last edit Nov 30, 2016 at 12:49 PM 2 rev

This company sells wines in cases of 12s and 6s and also individual bottles.

Under the table Quantity I have numbers that refer to cases of 12s, 6, and bottles.

Another table on the data source specifies the confituration of the cases, that is, if it is 1 case of 12, there will be a table Units Per Case under which there will be 12, or 6 for a case of 6.

My aim to create a formula to convert all cases to bottles.

Thank you for any help.