on 11-30-2016 12:45 PM
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.
Thank you for helping on that Brian and sorry for belated reply.
I will implement that formula and will give you a feedback.
Rony
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
11 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.