I had a question about using the Expression Builder for Item types. I have my excel set up and the Item types but when I go to use the expression builder it gives me a choice for everything except the one I am currently trying to make an expression for. I added some pictures to show how my expression builder looks and the excel for reference. If anyone could help with how my expression should be set up that would be great!
I tried to manual edit like you are saying and it just gives me an error in the expression and it says "A CalculatedECPropertySpecification with ECExpression of "LookUp.GetEntry("Project Information","Variable",this["FMS"])["Value"]" cannot be applied to the ECProperty "FMS" because it is dependent on that ECProperty". Here is the Excel sheet.
Project Information.xlsx
Hi Richard - just to verify the FMS value does not appear in the scroll list (left image) on the right hand side of the expression dialog? Have you tried copying the expression text shown and pasting in the FMS item type and replacing "County" with "FMS" as a manual edit?
Would you mind sharing the excel sheet so I could recreate on my end?
Thanks,
Justin
Justin Guiliano, PE