AnsweredAssumed Answered

Custom Property that rounds and concatenates two other custom properties

Question asked by Tim Miedzinski on Oct 17, 2018

I am trying to create a custom property that appears in the BOM to be used to help specify the material type.

Example: I have an aluminum hollow tube with some OD and ID (both are custom properties). I want to round these values to 2 decimal points and then concatenate them. So if OD was .543 and ID was .194, I would get a result of .54x.19. I have gotten thus far by doing the following:

custom properties:

OD = .543

ID = .194

SubCat = "rOD@8701-P-18-836.SLDPRT"x"rID@8701-P-18-836.SLDPRT"


global variables:

rOD = round("OD",2)

rID = round("ID",2)


However, I only want to use this custom property, SubCatName, if another custom property is greater than 0. I can't seem to put the "SubCatName" in the result of an IIF statement in the equation for a global variable.


Is this possible? I'm hoping there is a simple enough workaround that won't require any changes to our business tool that we use to analyze our BOM. Thanks in advance.