Is Whole Number? 1

[MeganRoss]

I have to create a formula something like this:

if {order_qty}/{case_pack_qty} <> WHOLE NUMBER then "NOT FULL CASE PACK" else ""

How do I determine whether or not {order_qty}/{case_pack_qty} actually equals a whole number or if it has a fraction. Basically if it does not divide evenly I need it give me an alert.

Keep in mind {order_qty} and {case_pack_qty} are continuously changing.

Any ideas? I'm sure this is something simple but I can't figure it out.

 

[Turkbear]

Hi,
Try:

if Trunc({order_qty}/{case_pack_qty}) <> ({order_qty}/{case_pack_qty} )
then
 "NOT FULL CASE PACK" 
else ""

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[MeganRoss]

That worked. Thank you.