2021-02-08 06:10 PM - last edited Wednesday by Laszlo Nagy
2021-02-08 07:32 PM
2021-02-08 11:09 PM
2021-02-09 09:01 AM
2023-02-14 06:05 PM
This is giving me a Syntax Error. When I jump to the last valid character, it's right after CONCAT
2023-06-02 10:47 PM
I'm having similar syntax error as reidweber. Hoping to open the thread again to find a solution. Rather than /12 I would like to put /1'-0" at the end of the expression. Would that be .... /1\'\-\0\"")
2024-08-03 08:04 PM
The error at CONCAT is your local language setting of your system. You need to put a comma in the list of elements being operated on by the CONCAT. The person posting CONCAT ( STRCALCUNIT ( 1 ft * TAN ( {Property:Roof/Pitch} ) ); "/12\"" ) is somewhere where they use a semicolon.
2024-08-04 09:39 PM - edited 2024-08-04 10:07 PM
Here's an expression that will yield a label that looks like 3/4"/12". One issue that comes up if you have calculation units set to feet and inches is that the label will throw up a value like 0'-3/4", which isn't kosher.
The 0'- gets replaced with a null ("").
REPLACE ( CONCAT ( STRCALCUNIT ( 12 in * TAN ( {Property:Roof/Pitch} ) ), "/12\"" ), 1, 3, "" )