RE: A field which returns a value that is a multiple of another value
I have a integer field on the item record called the “pack size” {packsize}
I would like to create a new integer field “minimum order quantity” {MOQ}.
The requirement is to make the {MOQ} field only allow a user to enter a multiple of the {packsize}.
Can someone assist me with a formula that I could use in a workflow or on the field setup to restrict entry of the {MOQ} so its only multiples of the {packsize} field?
EXAMPLE
IF {pack size} = 6
THEN {MOQ} = should only allow values = 6,12,18,24,30…etc.
You can use another custom field as the multiplier and make MOQ a formula which multiplies packsize by the multiplier.
