Skip to Content
0

Different Units of Measure for the same product

Nov 30, 2016 at 12:45 PM

31

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Brian Dong Nov 30, 2016 at 05:14 PM
0

Hi Rony,

You can create your formula something like:

Select {table.CaseSize) 
    Case 12: 12 * {table.QUANTITY} 
    Case 6: 6 * {table.QUANTITY} 
    Default: {table.QUANTITY}; 

So based on the case size, the formula will multiply the case size by the quantity. The default will be 1 which is just the quantity.

Hope this helps,

Brian

Share
10 |10000 characters needed characters left characters exceeded
Dirty Rony Mar 10, 2017 at 10:44 AM
0

Thank you for helping on that Brian and sorry for belated reply.

I will implement that formula and will give you a feedback.

Rony

Share
10 |10000 characters needed characters left characters exceeded