Valid if question

expressions
(Antony Cole) #1

Hi Everyone, I have 2 columns [Min Order Qty] and [Order Qty]. I want only to allow multiples of the [Min Order Qty] in [Order Qty]. So if [Min order Qty]=25 then [Order Qty] to only allow multiples of 25. Please can someone help me with the expression.

Thanks

Antony

(Levent Kulacoglu) #2

@AntonyCole1979
You can use this expression in Valid_if property of [Order Qty] column

MOD([Order Qty],[Min Order Qty]) = 0

2 Likes
(Antony Cole) #3

Thanks for your help

Antony