Forum Discussion
Shipping calulator
Hi,
Is it possible to write a formula that would indicate the size of the package?
Example:
250 pieces = 1 carton "a"
500 pieces = 2 cartons "a"
370 pieces = 1 carton "a" and 1 carton "b"
240 pieces = 2 cartons "b"
I have 811 pieces in my order and I would like BI to indicate what sizes of packages to use (in this case, 3x carton "a" and 1x carton "b")
carton "a" = 250 pieces
carton "b" = 120 pieces
Is it possible?
Anonymous , Try a measure or column like
column =
Quotient([Value],250) & "Carton a" & Quotient(Mod([Value],250),120) & "Carton b"
Measure =
var _val = sum(Table[Value])
return
Quotient(_val ,250) & "Carton a" & Quotient(Mod(_val ,250),120) & "Carton b"
2 Replies
Anonymous , Try a measure or column like
column =
Quotient([Value],250) & "Carton a" & Quotient(Mod([Value],250),120) & "Carton b"
Measure =
var _val = sum(Table[Value])
return
Quotient(_val ,250) & "Carton a" & Quotient(Mod(_val ,250),120) & "Carton b"