Formula to show both inches and mm for a length

[djmjr]

Hi everyone I'm hoping you can help me out here.

I've attach a picture that I hope helps to see what I am trying to do.

My global units is set to inches, because I am primarily working to inches. However, I am using components that require a metric designation in their part number. What I am trying to do is have a formula that sees the length of the pad, converts that number to the metric equivalent, then shows that automatically in both the Product Description and Part Number. I thought the round(L,"mm",1) would do that for me, but it didn't do what I thought.

Any help will be appreciated.

Thanks

 

[dougsnell]

If you are just looking for the numeric value you could utilize the following: ToString( Length.1 *25.4/1in ) If you want to include the units you could concatenate them with ToString( Length.1 *25.4/1in ) + "mm"

--Doug

 

[djmjr]

Thanks, appreciate the help. Your suggestion was helpful.