If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Validating a resultant number against a number
Hi everybody.
I em making a purchase order fomrat with the capability of a Kanban supply system, and I need the customer to order no more than the specified pallets of product. I have several columns where the customer will enter the amount of pallets neded for each product, and then at the end the format will sum all the pallets, but I need a function so that when the customer enter the amounts and the sum of the pallets in the bottom, passes the specification, a message error pops up to indicates the client that he had passed the limit of pallets to order. I tried the "Validation" function in the Data menu, but it does not recognizes the sum as a whole number. I hope you can help me -- Kind Regards Pablo Fernandez |
#2
|
|||
|
|||
Validating a resultant number against a number
Is it possible that your sum looks to be say 7, but is really 6.9?
-- HTH, Barb Reinhardt "Pablo Fernandez" wrote: Hi everybody. I em making a purchase order fomrat with the capability of a Kanban supply system, and I need the customer to order no more than the specified pallets of product. I have several columns where the customer will enter the amount of pallets neded for each product, and then at the end the format will sum all the pallets, but I need a function so that when the customer enter the amounts and the sum of the pallets in the bottom, passes the specification, a message error pops up to indicates the client that he had passed the limit of pallets to order. I tried the "Validation" function in the Data menu, but it does not recognizes the sum as a whole number. I hope you can help me -- Kind Regards Pablo Fernandez |
#3
|
|||
|
|||
Validating a resultant number against a number
Thanks barb for your interest in helping me.
If I have a result in the sum of the columns, it should no be greater than say 30 pallets, so if the customer is entering data and after enetering 30 pallets he wants to enter another pallet (31) then an error messaje will let him know that he is exceeding the specified amount which is 30, -- Kind Regards Pablo Fernandez "Barb Reinhardt" wrote: Is it possible that your sum looks to be say 7, but is really 6.9? -- HTH, Barb Reinhardt "Pablo Fernandez" wrote: Hi everybody. I em making a purchase order fomrat with the capability of a Kanban supply system, and I need the customer to order no more than the specified pallets of product. I have several columns where the customer will enter the amount of pallets neded for each product, and then at the end the format will sum all the pallets, but I need a function so that when the customer enter the amounts and the sum of the pallets in the bottom, passes the specification, a message error pops up to indicates the client that he had passed the limit of pallets to order. I tried the "Validation" function in the Data menu, but it does not recognizes the sum as a whole number. I hope you can help me -- Kind Regards Pablo Fernandez |
Thread Tools | |
Display Modes | |
|
|