Carla,
I didn't see any responses so I thought I would give it a shot. This is
untested so may not work.
Magic math adds decimals when you use addition or multiplication and subtract
when you use subtraction or division. So you are essentially dividing (as an
example) 114 by 2.54 which leaves you with no decimal places therefore your
formatting of 2D gives a .00.
Give this a shot:
IFE=P(R,S,IF{([ANS,"my_cm_query"]|0^CM)
CM*1.00^CM,CM/2.54:2D}^/[ANS%0,"my_in_query"]|0)^#
I hope this helps.
--
Bill Palmer
Financial Coordinator, Information Sys
Mid-Columbia Medical Center
The Dalles, OR 97058
541-296-7417
>>> On 1/10/2007 at 7:12 am, in message
<[EMAIL PROTECTED]>, "Carla Fuller"
<[EMAIL PROTECTED]> wrote:
>
> 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
