Won't work, can't figure out why.
"T3"=iif("T1"-"T2">0,"T2"+1,"T3")
"T88Qty"=iif("Overall@LAYOUT"<200,0,"T3"-2)
Everything before "T3" works fine, I have other equations with "Overall@LAYOUT" in them. I have taken the "T3" out of the "T88Qty" equation and it solves just fine. For some reason when I put it back in, I get the evil red exclamation mark.
Tried creating another equation with "T1"-"T2" and my "T88Qty" is still not working.
"T3"="T1"-"T2" 0
"T4"=iif("T3">0,"T2"+1,"T2") 3
"T88Qty"=iif("Overall@LAYOUT"<200,0,"T3"-2) !
Tom,
Maybe this is ignorance speaking, but is there supposed to be a double "i" (iif) or is it
supposed to be (if). I am not fluent in this type of equation, but the ones I did do I don't
ever remember iif.
Nevermind. I just thought I would throw it out there. Somehow I figured that was the way it should be.
I agree, I still get frustrated when I forget one of the i's occassionally and get the incorrect syntax message.
Hey Tom, oh...disregard what I said about having to have a separate variable for a calculation within an IIF....WRONG...
It seems like you have a typo/mistake in your first formula though....
"T3"=iif("T1"-"T2">0,"T2"+1,"T3")
"T88Qty"=iif("Overall@LAYOUT"<200,0,"T3"-2)
That "T3" formula is referencing itself when the iif statement is false...I think that is what is causing you a problem...
Filipe
Yea, I caught that after I had posted the first time. I corected that and am still not getting any results.
then what is the rest of your statement after fixing that? You have to have a true and false value for the iif
"EndSectQty"=iif("Overall@LAYOUT">112,2,1)
"T1"=(("Overall@LAYOUT"-24)/88)
"T2"=int("T1")
"T3"=iif("T1"-"T2">0,"T2"+1,"T2")
"T88Qty"=iif("Overall@LAYOUT"<200,0,"T3"-2)
"EndOL"=iif("Overall@LAYOUT">112,("Overall@LAYOUT"-"T88Qty"*88)/2,"Overall@LAYOUT")
"EndSect@LAYOUT"=iif("EndSectQty">1,"EndOL"-12,"EndOL-24")
"T88Qty" is the first one that doesn't solve. Which, inturn, prevent the last two from solving.
Tom,
I was able to make a part and use all your equations and have them all solve without error. So it isn't your syntax at all. I've attached my part so you can see. Not sure what is going on for you but the info you have provided seems to work fine. What values are you starting with for your inputs? (EndSectQty, Overall@LAYOUT...)
sorry, just realized I put EndSecQty as an input... scratch that off your list
Tom,
Were you able to figure out a solution on this?
No, I ended up jast making a design table for the part. It makes modifying it a little more of a pain, but It's better than not working at all.
Hey Tom,
The problem is in that "T1" - "T2" ....don't ask me why, but the solution would be to create a separate variable with that value...
Cheers