Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Fraction to Decimal

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

4 Posts

3 Users

0 Reactions

71 Views

RSS

jessicaw

(@jessicaw)

Posts: 434

Prominent Member

Topic starter

Can someone help me with converting a Fraction to a Decimal? Here is what I am trying to achieve:

I am working on a custom OB form and weeks gestation is auto-generated as a fraction. I would like to set a button/function to convert that fraction to a decimal. And then set a function to add problems to the patients problem list based on that decimal value as well as a couple of other patient factors (gest age and gravid).

Posted : January 3, 2019 4:56 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Can you provide a sample or two of the typical output?

We do not use that form, so no idea what is stored. I am guessing something like '8 2/7 weeks'?

Posted : January 3, 2019 7:19 am

jessicaw

(@jessicaw)

Posts: 434

Prominent Member

Topic starter

Example: 19 2/7

Stored to OBS term "GEST AGE EST"

Here is the form:

OBFLOWSHEET PROBMED COMMENTS5(2)

My hope is to add a button that will evaluate the converted gest age. maternal age and gravid and then add the correct ICD10 problems for Weeks Gestation and Trimester. While also factoring in whether or not those problems are already part of the patients problem list.

Posted : January 3, 2019 8:22 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

The below function is how I would do this. I am assuming the Gestational Age is always done in a "XX X/7" format. The way it is written will work if they type in "19 0/7", but will not work if they type "19" by itself when they are at zero days.

{fn GestAgeToDecimal(gestAge){
//seperate the whole number from the fraction by the space
gestAgeArray = getfield(gestAge," ","")
//find if there is a forward slash in the gestAge. this will get us the numbers on each side of the slash
indexVar = match(gestAgeArray[2],"/")
//if there is a fraction, then calcuate the value.
if indexVar >0 then
numerator = sub(gestAgeArray[2],indexVar -1,1)
denominator = sub(gestAgeArray[2],indexVar +1,1)
decValue = val(numerator ) / val(denominator )
//add the decimal to the whole number
return val(GestAgeArray[1]) + decValue
else
//return blank if the gestAge passed in was not formated as "XX X/X"
return ""
endif
}}

GestAgeToDecimal("19 2/7") will return 19.29.

you can get a decimal from a fraction by converting the strings to values, and then putting it in the MEL code as a fraction: 2/7 = 0.29

Please let me know if you have any other questions. 🙂

Thank you,

Daniel C.

Posted : January 3, 2019 9:59 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
5 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0