Hi Carla,
I would try the following:
IFE=P(R,S,IF{([ANS,"my_cm_query"]|0^CM)
CM:4D/(2.54:2D)}^/[ANS%0,"my_in_query"]|0)^#
Meditech's division function / behaves a little differently than would be
expected (and it is a little difficult to put into words, so please bear with
me).
The number of decimal places in the quotient is equal to the number of decimal
places in the dividend minus the number of decimal places in the divisor. So,
in my example, the centimeters (the dividend) are formatted to have 4 decimal
places. The divisor (2.54) is formatted to have 2 decimal places. So 4-2 = 2.
So the quotient will have 2 decimal places.
A little odd, I know. Please let me know if you have any questions.
Good luck,
Brian Schmit
Interface People, LP
Office: 214-222-1125 ext. 306
Mobile: 617-823-9326
[EMAIL PROTECTED]
http://www.ipeople.com
<http://ipterm1.ipeople.org/exchweb/bin/redir.asp?URL=http://www.ipeople.com>
Hi all,
I know one of you has the answer that I can't find, and I need your help. I
have a simple little set up for calculating centimeters into inches. The
problem I am having is that my 2 decimal places always come out to .00, no
matter what! It doesn't matter if my cm are 114 or 112, I still always get
44.00. Can someone review my attribute and tell me where my problem lies?
IFE=P(R,S,IF{([ANS,"my_cm_query"]|0^CM) CM/2.54:2D}^/[ANS%0,"my_in_query"]|0)^#
Thank you!
Katie Wood
Applications Specialist
War Memorial Hospital
500 Osborn Blvd
Sault Ste. Marie, MI 49783
(906) 635-4663
[EMAIL PROTECTED]
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
To subscribe or unsubscribe to the meditech-l, visit MTUsers.COM.
To check the status of the meditech-l, visit MTUsers.NET.
For help, email [EMAIL PROTECTED]
______________________________________
meditech-l mailing list
[email protected]
http://mtusers.com/mailman/listinfo/meditech-l