Discussions

 View Only
  • 1.  If Statements with inches

    Posted 07-18-2022 12:53
    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([Trade Product Line Material - Material Description - Unit Calculation]="Per Piece",

    IF ([Material Description]="WEEP AID",[Plan/Trade Product Line - Plan - Bid Set Weep Aid]/[Trade Product Line Material - Material Description - Length],[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
    ------------------------------


  • 2.  RE: If Statements with inches

    Posted 07-20-2022 04:48
    Haven't tried it, but generally you have to escape the restricted characters:

    "This is the  \"Younameit\" Product" 

    ------------------------------
    Malcolm McDonald
    ------------------------------