Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table that has products and the number of orders in liters. I have another table that the product name with the conversion between liters and cases. The problem is that one product can have the same number of liters but different number of cases. So the cases is really dependent on which product it is.
Table 1: Order by volume
Product, Orders
A, 10 L
B, 20 L
C, 40 L
D, 80 L
Table 2: Conversion table
Product, Liters, Cases
A, 10 L, 2 Cases
B, 10 L, 3 Cases
C, 10 L, 1 Cases
D, 10 L, 6 cases
I need the ability to be able to toggle between liters and cases. What can I do?
you added Jonathan's and Massimo's liters?
post the script, if you can
I'm using this as the expression.
sum(
//liters
([Demand Confirmed] * vLiters)
+
//Cases
(([Demand Confirmed] * [L to CS Conversion]) * (1-vLiters) )
)
That would be me !! i copy/pasted something i should not have .here is the updated version...