Putting a sweep calculation as an informational column in an iPart table

[oransen]

I'd like to put a sweep calculation as an informational column in an iPart table. The calculation involves to straight lengths and an arc, so the calculation is quite easy, but I'm unsure as to how to get actual values (not just the equation) into a column of the iPart table.

When I add a user parameters which is LenA + LenB + LenArc these appear in the column of the table as is, not a value. Is this an iLogic/VB/VBA thing...?

As an aside it would be nice to be able to type = Length(Sweep1) API.

[JamieVJohnson2 · Accepted solution]

Use Excel.  Open the table in Excel, do your math, save as a calculated column.  Save and Close excel.  The column in the iPart table will then show up as red (calculated), and can only be edited further with Excel, but its values will be usable anywhere else.

[oransen]

Thanks @JamieVJohnson2 . In the meantime I tried with iLogic, but it was never clear when the calculation would happen. Your solution seems the best compromise.