Reading in the help file, it says I can use a YES/NO in an IF statement. However, no matter what I try I can't get it to evaluate the formula.
the attached screenshot errors with an "Improper use of Boolean"
The real IF statement I want here though is this;
Bolt Kit Qty is set to "INTERGER"
IF(AND (Bolts End 1 = 1, Bolts End 2 = 1), Bolt Kit Qty = 2, Bolt Kit Qty = 1)
Anyone have any idea of why these won't evaluate? I've tried TRUE, YES, 1, and none seem valid.
You want to change the number of bolts according to the check boxes? The formula needs to be in that parameters formula colum.
Yes/No parameters are assumed to be true so their syntax is a bit simpler than might be expected. In the image it looks like this:
Bolt Kit Qty = if(Bolts End 1, 1,2)
In plain english format: if Bolts End 1 is true use 1 if false use 2. There is no equal statement required, just the true and false values to use.
Steve Stafford
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
In short if end 1 is checked on, I want our QTY total to be 1, if end 2 is checked on, QTY total should be 1, but if both check boxes are on, the QTY should be 2.
Essentially it's a clip that holds down cable tray to strut. We have a single version that can be slapped anywhere, but I've also built a combined version that you can drop on the center of the tray, and set width for the tray, then toggle on or off which end, or possibly both ends that need the bolt kits. We want to be able to schedule for a QTY total.
I currently have the check boxes being pushed to a schedule to gather a total, but I think it would be much more streamlined if it was simply a number that can be totalled in the end. Currently I need two parameters to control End 1 from End 2, and in the "Assembled" version of the part I need to make sure the count shows a total of 2 instead of 1 per "assembly".
Since both have been built as a shared parameter, it's working as intended with the checks, but I still want numbers as it doesn't provide a "Total" of true values.
The attached image will use 0 if neither box is checked, 1 if just one is checked and 2 if both are checked.
Formula is written:
if(and(Bolts End 1, Bolts End 2), 2, if(Bolts End 1, 1, if(Bolts End 2, 1, 0)))
Plain english format: if Both parameters are check use 2, if this one is checked use 1, if this other one is checked use 1, if neither are checked use 0
Steve Stafford
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
