PaulElliott
3 years agoQrew Member
If Statements with inches
So I may have caused myself issues with my setup. But my problem is doing If statements with conditions which have an Inch (") in the name.
Ceil(If(="Per Piece",
IF ([Material Description]="WEEP AID",[Plan/Trade Product Line - Plan - Bid Set Weep Aid]/,[Material description]="4" DIAMOND LATH STRIPS",0),0)
)
I stopped because I have numerous Material Descriptions which include (") identifier in the name such as the Diamond Lath Strips. I guess I could go through and change all the names to read inch but there's a lot of them. Is there a ' function which allows me to bypass the problem?
------------------------------
Paul Elliott
------------------------------
Ceil(If(="Per Piece",
IF ([Material Description]="WEEP AID",[Plan/Trade Product Line - Plan - Bid Set Weep Aid]/,[Material description]="4" DIAMOND LATH STRIPS",0),0)
)
I stopped because I have numerous Material Descriptions which include (") identifier in the name such as the Diamond Lath Strips. I guess I could go through and change all the names to read inch but there's a lot of them. Is there a ' function which allows me to bypass the problem?
------------------------------
Paul Elliott
------------------------------