An additional shot of the current Sort using the Calculation above.
It looks from here like you can perform a find for what you need by specifying > 0 in the PartsDue field.
Your suggestion led to the idea of making a field called "Partial Order ~ Full" with the following calculation:
If ( Parts Ordered > Parts Turned In and Number of Parts Due < Parts Ordered ; "Partial Run" )
Then, in my Find script I put:
Enter Find Mode
Set Field [Stock Transaction::Partial Order ~ Full ; "Partial Run"]
This worked great. Basically, I took the calculation out for the find script and just made it into its own global calculation field that i could search by normal means.
I'm not using the (Partial Order ~ Full) field in a layout, it's simply there in my Stock Transactions Table as a place to search for what I want. In this case, I wanted to search for anything that equaled a "Partial Run" or (according the If statement calculation) was True. I set the calculation filed to return the result as (Text). I Then used the the text "Partial Run" in place of a 1 or 0 in the If statement. I would have used a 1 (True) if I had set the calculated result to be a number.
It's not as elegant as I would like, but it gets the job done for now.
Thank you again.
But I see no need for the calculation field when you, or a script can use the > 0 Criteria in the parts Due field.