Skip to Content
avatar image
Former Member

Different Units of Measure for the same product

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Nov 30, 2016 at 05:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 10, 2017 at 10:44 AM

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

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

    Rony

    Add comment
    10|10000 characters needed characters exceeded