I am trying to create a BAQ where the user enters a quantity and a part number and the query returns a list of materials, the quantity on hand, the quantity needed (calculation based on the quantity entered by user), and the difference between the quantity on hand and the quantity needed (calculation).
How do I create a calculated field to hold the value of the parameter entered by the user? I have tried the following (all of which gave me syntax errors)
Created the parameter, created a calculated field and entered the expression = @QtyNeeded as the calculation of the field
Created the calculated field and entered = 0 as the calculation of the field.
Not really sure where to go from here. Seems to me this should be pretty straightforward, but I can’t figure it out.
It let me save the field, so let me see if it lets met use the field the way I want to. I am getting the message when I click the Check Syntax button, so maybe it’s just an errant message, rather than an actual problem.