Carla, You could try removing the :2D, which is telling the division to be two decimal points. And ensure that your query isn't set to two decimal points as well.
Daniel Davis, RN ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Carla Fuller Sent: Wednesday, January 10, 2007 9:13 AM To: [email protected] Subject: cm to inches, problem with decimal 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
