Rounding of values calculated from the Content Center

[Francisco_García]

Hello,

I have a question regarding the use of calculated columns in an Autodesk Inventor Content Center table.

I created a column with a mathematical expression (formula) directly in the table, and I need the result to be limited to integer values. However, when I try to apply functions like round, floor, or ceil, the system doesn't recognize or allow them.

I know this could normally be resolved from the Parameter Manager, but in this case, I'm working exclusively within the Content Center environment.

Is there a way to force rounding of these values in that context? Or is this a system limitation that prevents the use of rounding functions in calculated columns in Content Center?

Thank you in advance!

[SharkDesign · Accepted solution]

You can do this, but it is a bit complicated as the result of the formula has to exactly match the units you chose and not mm2 for instance. 

If you use edit in Excel instead you might get a better result then trying to do it inside the CC UI.

You spelt 'Length' wrong, just checking that isn't what causes it to go red. 

Also 'ceiling' is just 'ceil'

https://help.autodesk.com/view/INVNTOR/2024/ENU/?guid=GUID-EE98BCED-5623-4E3B-9E98-432C6738B081

[Roman_Vesely · Accepted solution]

Hi @Francisco_García 

in CC editor we supports only "Functions, prefixes, and algebraic operators" described: here https://help.autodesk.com/view/INVNTOR/2024/ENU/?guid=GUID-EE98BCED-5623-4E3B-9E98-432C6738B081

and as mentioned  SharkDesign below, you have to use required Unit Types. For many functions, only "ul" units are supported as input/output.

Regards

 Roman

[CGBenner]

@Francisco_García 

Did the information provided answer your question? If so, please use Accept Solution so that others may find this in the future. Thank you very much!