Doesnt the calc have to be .05 * Stock Received ?
Hi Mr. Vodka,
I'm sorry youre right, it should be .05, but my script is not working.
I don't understand the logic here.
I have a field Reorder_Level, with a calculation (.05 * Stock Received).
So let's say Stock Received contains 100. 5% of 100 is 5. If you are searching for <=.05, you won't find it.
It seems to me that you need TWO fields to begin with: one to say how much you have, the other how much you should have. Then you can calculate whether the stock is below 5% of the prescribed quantity, and find those records.
I'm sorry for making you confuse. I changed now my original post.