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

MEL Math: Limiting Value to Decimal Places

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

3 Users

0 Reactions

55 Views

RSS

Sam

(@sam)

Posts: 371

Honorable Member

Topic starter

Howdy Fellow CHUGgers!

Looking to find the syntax or verbiage for limiting a numerical result to x number of decimal places. Let's say, two for this example (x.xx).

Bonus Points: Linking to an online information source for this kind knowledge (0 points awarded for linking to CHUG forums). 😉

Thanks!

Posted : February 27, 2017 8:09 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

Would you like to round your result? If so there is a built in function for that. From CPS help:

round

description

Rounds a value to the specified decimal point.

type

MEL utility function

syntax

round(value, point)

arguments

value	The value to round
point	The number of places after the decimal point after rounding returns Rounded number

example 1

{fn RND_HT( ){ //define function

local hgt = val(OBSANY("Height"))

round(hgt,0)}}

example 2

{RND_HT( )} //call function

Returns 76 where OBSANY(’Height’) returns 75.75

The function defined in this example uses round() to return a rounded height value.

You can also use truncate is you don't want to round your value. Also from CPS help:

description

Shortens a value to the specified decimal point.

type

MEL utility function

syntax

truncate(value, point)

arguments

value	The value to truncate
point	The number of spaces after the decimal point after truncating

returns

Truncated number

comment

N/A

example

{fn TNC_HT(){ //define function

local ht = val(OBSANY("Height"))

truncate(ht,0)}}

{TNC_HT( )} //call function

Returns 75 where OBSANY(’Height’) returns 75.75

The function defined in this example uses truncate() to return a truncated height value.

Posted : February 27, 2017 8:23 am

Sam

(@sam)

Posts: 371

Honorable Member

Topic starter

bhoover for the win. + bonus bonus points. 🙂

THANKS!

Posted : February 27, 2017 8:27 am

Sam

(@sam)

Posts: 371

Honorable Member

Topic starter

I have the below code, but it will not round or limit the results to the two decimal places as I want. It goes out to the 6th decimal place.

//Weight Conversion to KG
{fn RND_WT(val1){//rounds KG to 2 decimal places
local wt = (val1 * 0.45)
round(wt,2)}}

{!DOCUMENT.PT_WEIGHT_KG = RND_WT(DOCUMENT.PT_WEIGHT)}

Posted : February 27, 2017 9:27 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

It may be that your function is not returning a value. try this:

//Weight Conversion to KG

{fn RND_WT(val1){//rounds KG to 2 decimal places

local wt = (val1 * 0.45)

return round(wt,2)}}

{!DOCUMENT.PT_WEIGHT_KG = RND_WT(DOCUMENT.PT_WEIGHT)}

Posted : February 28, 2017 12:16 pm

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 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