TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Condense Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Mime-Version:
1.0
Content-Type:
text/plain; charset="utf-8"
Date:
Thu, 21 May 2015 09:51:15 -0400
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
Subject:
Content-Transfer-Encoding:
quoted-printable
Message-ID:
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
From:
Cornelius Marr <[log in to unmask]>
Parts/Attachments:
text/plain (23 lines)
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.

ATOM RSS1 RSS2