Hi Alicia,
Here is another basic formula that you can use to substitute your dimension field as needed, which will convert it to the approximate inch in decimals. Creating a view to isolate your specific dimension element can also be very useful to avoid the need for subreporting.

Round({Dimensions.Dimension}/2.54,3)]

Feel free to respond directly if you have any questions about the formula.

Cornelius

Cornelius Marr
JWSC LLC – Art Catalogues, Research, and Collection Services
212 South Marion Street, Suite 5  Oak Park, IL 60302
(708) 445-9101  |  www.jwscllc.com

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.