This has got to be easy, but my Google skills are failing. I need to test a result as to whether it's a whole number or not.
We only ship full master cartons. I need a True or False on whether the QtyOrdered meets full master carton quantities.
FullMC: [QtyOrdered]/[MCQty] Example: 7/20 = 0.35 = False
FullMC: [QtyOrdered]/[MCQty] Example: 80/20 = 4 = True
FullMC: [QtyOrdered]/[MCQty] Example: 82/20 = 4 = False
What function is used for validating whole numbers?
Thanks!