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

help using round function

Trading Post

Last Post by rspartos 11 years ago

13 Posts

3 Users

0 Reactions

86 Views

RSS

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

I could really use some help learning how to use the below function.

I looked at the EMR help and am not successful in getting this function to work. I don't really understand the example given.

{fn RND_HT( ){ //define function

local hgt = val(OBSANY("HEIGHT")

round(hgt,0)}}

does anyone have some insight or help to offer?

-richard

Posted : January 24, 2014 12:49 am

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

it looks like you are trying to use round(), the function takes a numerical value and rounds it to the specified number of decimal places. There are two arguments, the first is the value to be rounded (it must be a value, not a string) and the second is the number of decimal points (again, a numerical value, not a string)

These are incorrect -

round("74.0090",2)

round("74.0090","2")

round(74.0090,"2")

This is correct -

round(74.0090,2)

If you are trying to round an observation or document variable, it is likely stored as a string. If you do this -

round(val(document.variable),2)

That will probably work for you. Val() converts a string to a value just as str() converts a value to a string. Hope that helps

Posted : January 24, 2014 1:20 am

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

gibsonmi said:

If you are trying to round an observation or document variable, it is likely stored as a string. If you do this -

round(val(document.variable),2)

That will probably work for you. Val() converts a string to a value just as str() converts a value to a string. Hope that helps

It definitely looks helpful. So, to be more clear. If I wanted to round a variable: in the "white area" of VFE I would put something like

{if DOCUMENT.VALUE1 <> "" then DOCUMENT.VALUE2 = round(val(document.VALUE1),2) etc... }

Am I on the right track?

Posted : January 24, 2014 2:21 am

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

Ok so, I got it to round to the nearest 100th, which is nice, but I still have zeros trailing past the second decimal. so, the value actual value is 1.029123456789 and the round() returns 1.03000000000. Is there a way for me to format this so the number looks like 1.03?

Thanks again for the help!

Posted : January 24, 2014 3:30 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

truncate
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.

where used

Chart: templates for letters and handouts, text components, quick text

Encounter Form Editor: MEL expressions, data displays, text translations

Posted : January 24, 2014 4:05 am

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

I tried this too. Still, pretty much the same result. instead of 1.079123456, I get 1.070000000

so, I figure something is wrong with - {if document.variable1 <> "" then document.variable2 = truncate(val(document.variable1),2) else "" endif}

help please....

Posted : January 27, 2014 1:19 am

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

This should work for you

{fn RemoveEndZero(var){
//use a string for var

while sub(var,size(var),1) == "0" do
var = sub(var,1,size(var) - 1)
endwhile

return var

}}

{if document.variable1 <> "" then document.variable2 = RemoveEndZero(round(val(document.variable1),2)) else "" endif}

Posted : January 27, 2014 1:27 am

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

Actually, I should have converted that to a string first, my bad

{if document.variable1 <> "" then document.variable2 = RemoveEndZero(str(round(val(document.variable1),2))) else "" endif}

Posted : January 27, 2014 1:37 am

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

Oooooh! that works really well. Thank you very much!!!

Posted : January 27, 2014 2:19 am

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

Thanks again for the help. It turns out that the function above removes all end zeros, so even if the value has no decimals, the zeros do not show ex 10 = 1 (which is not good). So, I think I figured out the solution, but if you see something is wrong with what I am leaving below, please let me know... also, I decided to truncate instead of round. I am not sure if that makes a difference, though.

{fn RemoveEndZero(var){

while sub(var,size(var),1) == ".0" do
var = sub(var,1,size(var) - 1)
endwhile
return var
}}
{if DOCUMENT.VARIABLE1 <> "" then DOCUMENT.VARIABLE2 = RemoveEndZero(str(truncate(val(DOCUMENT.VARIABLE1),2))) else "" endif}

Posted : January 28, 2014 11:31 pm

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

Yeah, it was looking at the last character and removing it if it was a zero. That wont work because you are asking it to remove the last character if it is equal to ".0" which it never will be because thats two characters. You could take a different approach, like pass a number of decimal places to keep to matter what, I just thought the zeros might be easier, I can see where that would have problems though. I dont understand why truncate wouldnt just actually truncate the number, but we can find a way around it.

Try something like this, didnt test it, but tried to explain what I was doing -

{fn DecimalPoints(var,num){
//use a string for var
//num is number of decimal points to keep, use a value

//if there is no decimal point return the string unchanged
if match(var,".")<1 then return var endif

//if it already has the specified number or less decimal points, return the string unchanged
if (match(var,".") + num) >= size(var) then
  return var
else
  //otherwise find the decimal, move num places to the right and return the string up to that point
  return sub(var,1,match(var,".") + num)
endif

}}

Posted : January 28, 2014 11:47 pm

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

That works really well.

At this point I have tried all the functions you've thrown my way. I really appreciate it. Laugh

I figured you would say what you said about the ".0", but regardless of it not suppose to be working, it works. Could you take another look at it or test it out and see what I mean. I can e-mail you the form I am working on (not quite sure how to upload) Confused with the function that isn't suppose to work. But from my amateurish POV and lower intermediate skill set, it does work and it looks like it says

//if it ends in ".0" then remove the zeros following the second decimal point//

this is exactly what I put in the white space in VFE

{fn RemoveEndZero(var){
while sub(var,size(var),1) == ".0" do
var = sub(var,1,size(var) - 1)
endwhile
return var
}}{if DOCUMENT.VARIABLE1 <> "" then DOCUMENT.VARIABLE2 = RemoveEndZero(str(truncate(val(DOCUMENT.VARIABLE1),2))) else "" endif}

On the other hand, I agree, truncate and round should probably work just fine. Is it possible that my shoddy coding technique would void the function, truncate(value,2), and cause a value to = something like 1.08000 instead of 1.08?

Has anyone else tried the truncate functions?

Posted : January 29, 2014 6:44 am

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

In case anyone is interested, I figured out why the function seemed to work. A response from any of the more seasoned MEL coders is much appreciated, here.

the function doesn't work, like Michael said.

What seems to work is the following part

str(round(val(DOCUMENT.VARIABLE),2)) this returns a number and a decimal to the second position ex. 12.2265 is shown as 12.23

I guess that's how the round/truncate function example should look in the EMR...

unless you like the trailing zeros Confused

Posted : February 12, 2014 6:40 am

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