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

Data Display MEL Expression into chart note

Page 1 / 2 Next

Trading Post

Last Post by Anonymous 1 second ago

18 Posts

3 Users

0 Reactions

226 Views

RSS

mrooney

(@mrooney)

Posts: 50

Trusted Member

Topic starter

Hello everyone,

I'm building a form that will dispaly both GFRC and CKD Stage. I've gotten the results to display using a mel expression, but I'm not sure how I can translate this into the chart note. Please see the form below. Thanks for the help.

Laboratory - Changes1

Posted : November 14, 2014 8:41 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

Copy your code you created to calculate these over to the Translation tab. It should be in the Chart Note box. You'll also need to label it, so just put "GFRc: " + in front of your round() function and "CKD Stage: " + in front of your other code.

Posted : November 14, 2014 9:00 am

mrooney

(@mrooney)

Posts: 50

Trusted Member

Topic starter

Hey MikeSeale,

It's interesting because if I enter the same exact code into the translation tab I get MEL vomit errors.

Thanks,
Mike

Posted : November 14, 2014 9:25 am

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

"...I’ve gotten the results to display using a mel expression..."

I would do something like this...

Take the {....} code from your data display

Assuming there is an obsterm("X") that I am displaying some result of it in the data display

In the MEL area on the right, define a new document variable

{DOCUMENT.displayThis = fnDisplayThis( obsnow("X") ) }

{fn fnDisplayThis( theObsvalue ) {

local strVal = ""

... mel code from data display calculating using theObsvalue ...

strVal = ...whatever is the final value of the mel code ...

return strVal

}}

Then in the data display Text Translation, put:

{ DOCUMENT.DisplayThis }

If you do not follow what I am talking about, post your MEL code here for us to see what you are doing...

- Beverly

Posted : November 14, 2014 10:27 am

mrooney

(@mrooney)

Posts: 50

Trusted Member

Topic starter

Laboratory - Changes1 <--- Here is the form I'm working with.

Mel Expression:

GFRc: {if OBSANY("Creatinine") == "" then "***" else "GFRc: " round(175 * (OBSANY ("Creatinine")^ -1.154) * (PATIENT_AGE()^-0.203) * (if PATIENT.SEX =="F" then 0.742 else 1 endif) * (if PATIENT.RACE == "Black or African American" then "1.212" else "1" endif),1) endif}

CKD Stage:

{MDRD4 = 175 * (OBSANY ("Creatinine")^ -1.154) * (PATIENT_AGE()^-0.203) * (if PATIENT.SEX =="F" then 0.742 else 1 endif) * (if PATIENT.RACE == "Black or African American" then "1.212" else "1" endif) cond case MDRD4 =="" " " case MDRD4>=90 "Normal Kidney Function" case MDRD4<90 AND MDRD4>=60 " 2 +" case MDRD4<60 AND MDRD4>=45 "3A" case MDRD4<45 AND MDRD4>=30 "3B" case MDRD4<30 AND MDRD4>=15 "4" case MDRD4<15 "5" endcond}

Posted : November 14, 2014 10:33 am

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

OK, I will tackle the first one. I have not tested it, try it and see if this works. If it does, try writing the next one and let us know how that goes...

Here was your Original mel code from the Data display:
GFRc: if OBSANY("Creatinine") == "" then
"***"
else
"GFRc: " round(
175 * (OBSANY ("Creatinine")^ -1.154) * (PATIENT_AGE()^-0.203)
* (if PATIENT.SEX =="F" then 0.742 else 1 endif)
* (if PATIENT.RACE == "Black or African American" then "1.212" else "1" endif)
,1)
endif

Try replacing it with the following...
Add this to the MEL code area on the Right:

{DOCUMENT.displayGFR = fnCalcGFR( OBSANY("Creatinine") )}

{fn fnCalcGFR( obsVal ) {
local sRet=""
if OBSANY("Creatinine")=="" then
sRet = "***"
else
local sexCalc = (if PATIENT.SEX=="F",0.742,1)
local raceCalc = (if PATIENT.RACE=="Black or African American", 1.212, 1)
local obsCalc = (OBSANY("Creatinine")^ -1.154) * (PATIENT_AGE()^-0.203)
sRet = round(175 * obsCalc * sexCalc * raceCalc, 1)
endif
return sRet
}}

Add this to the Data Display on the Form
In the Mel Expression connection put
{ "GFRc: " + DOCUMENT.displayGFR }

In the Text Translation put this:
{ FMT("GFRc: ","B") + DOCUMENT.displayGFR }

Let me know if this worked 🙂

- Beverly

Posted : November 14, 2014 1:30 pm

mrooney

(@mrooney)

Posts: 50

Trusted Member

Topic starter

No luck 🙁

Posted : December 23, 2014 9:17 am

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

I tested this code, and it works to display the GFRc in the data display and in the text translation (Chart Note):


I put this into the data display

Connection: MEL Expression

{"GFRc: " + DOCUMENT.displayGFR }
Translation:

{if DOCUMENT.displayGFR=="" then FMT("GFRc: ","B") + DOCUMENT.displayGFR else "" endif}
I put this calculation function and document variable on the right in the MEL coding area of the Form:
{DOCUMENT.displayGFR = fnCalcGFR( OBSANY("Creatinine") )}
{fn fnCalcGFR( obsVal ) {

local sRet=""

if obsVal=="" then

 sRet = "***"

else

 local sexCalc = (if PATIENT.SEX=="F",0.742,1)

 local raceCalc = (if PATIENT.RACE=="Black or African American", 1.212, 1)

 local obsCalc = (obsVal^-1.154) * (PATIENT_AGE()^-0.203)

 sRet = round(175 * obsCalc * sexCalc * raceCalc, 1)

 endif

 return sRet

 }}
Let us know if this works for you – Beverly


                    
                    	
                            Posted : December 23, 2014 10:29 am



        
        
    
				
                            
                
                	                		
                                        
                        			
			                
					
		 mrooney
                        (@mrooney)
                        
                                                    
                        
                            Posts: 50                        
                        
                            Trusted Member                        
                            
		              
	                    
                    
                

                
                	
                         Topic starter
	                         
                    	
							                        
                                            
                    
                        It worked in the data display, but not the translation. Thanks for your efforts. 
-Mike
                                                                                                	                                                
                                                         
                                                    
	                                        
                    
                    	
                            Posted : December 24, 2014 6:22 am		                    
						
                    	
                    
                

                
              

          


        
        
    
				
                            
                
                	                		
                                        
                        			
			                
					
		 mrooney
                        (@mrooney)
                        
                                                    
                        
                            Posts: 50                        
                        
                            Trusted Member                        
                            
		              
	                    
                    
                

                
                	
                         Topic starter
	                         
                    	
							                        
                                            
                    
                        Ok. I got the text translation to work for GFRC. Thanks again! Now I will take a stab at the CKD Stage.
                                                                                                	                                                
                                                         
                                                    
	                                        
                    
                    	
                            Posted : December 24, 2014 6:55 am		                    
						
                    	
                    
                

                
              

          


        
        
    
				
                            
                
                	                		
                                        
                        			
			                
					
		 blackmanb
                        (@blackmanb)
                        
                                                    
                        
                            Posts: 268                        
                        
                            Reputable Member                        
                            
		                  
	                    
                    
                

                
                	
                                                 
                    	
							                        
                                            
                    
                        Was it this line ?

Translation:

{if DOCUMENT.displayGFR=="" then FMT("GFRc: ","B") + DOCUMENT.displayGFR else "" endif}
Looks like I should have put <> instead of ==

Translation:

{if DOCUMENT.displayGFR<>"" then FMT("GFRc: ","B") + DOCUMENT.displayGFR else "" endif}
sorry about that.
                                                                                                	                                                
                                                         
                                                    
	                                        
                    
                    	
                            Posted : December 29, 2014 12:22 pm		                    
						
                    	
                    
                

                
              

          


        
        
    
				
                            
                
                	                		
                                        
                        			
			                
					
		 mrooney
                        (@mrooney)
                        
                                                    
                        
                            Posts: 50                        
                        
                            Trusted Member                        
                            
		              
	                    
                    
                

                
                	
                         Topic starter
	                         
                    	
							                        
                                            
                    
                        Yep, that was the issue. I'm having trouble solving the next translation for CKD stage. Please let me know if you have any ideas. You've been a huge help so far.  
{MDRD4 = 175 * (OBSANY ("Creatinine")^ -1.154) * (PATIENT_AGE()^-0.203) * (if PATIENT.SEX =="F" then 0.742 else 1  endif) * (if PATIENT.RACE == "Black or African American" then "1.212" else "1"  endif)  cond  case MDRD4 ==""    " "  case MDRD4>=90  "Normal Kidney Function"  case MDRD4=60  " 2   +" case MDRD4=45  "3A" case MDRD4=30  "3B" case MDRD4=15  "4"  case MDRD4<15 "5" endcond}
                                                                                                	                                                
                                                         
                                                    
	                                        
                    
                    	
                            Posted : December 30, 2014 2:57 am		                    
						
                    	
                    
                

                
              

          


        
        
    
				
                            
                
                	                		
                                        
                        			
			                
					
		 blackmanb
                        (@blackmanb)
                        
                                                    
                        
                            Posts: 268                        
                        
                            Reputable Member                        
                            
		                  
	                    
                    
                

                
                	
                                                 
                    	
							                        
                                            
                    
                        
 Your case statement was missing its else before the endcond.

Following the same style of solution as I showed for GFRc, 
here is the MEL code function and new document variable: 
DOCUMENT.displayMDRD4.

I have not tested this, but should work. 

{DOCUMENT.displayMDRD4 = fnCalcMDRD4( OBSANY("Creatinine") )}

{fn fnCalcMDRD4( obsVal ) {
 local sRet=""
 if obsVal=="" then
 sRet = "" // ? did you want to return "***" here, like with GFRc
 else
 local MDRD4=""
 local sexCalc = (if PATIENT.SEX=="F",0.742,1)
 local raceCalc = (if PATIENT.RACE=="Black or African American"
, 1.212, 1)
 local obsCalc = 175 * (obsVal^-1.154) 
* (PATIENT_AGE()^-0.203) 
* sexCalc * raceCalc

MDRD4 = obsCalc

cond
 case MDRD4 ==""
 sRet=" "
 case MDRD4>=90
 sRet="Normal Kidney Function"
 case MDRD4=60
 sRet=" 2 +"
 case MDRD4=45
 sRet= "3A"
 case MDRD4=30
 sRet="3B"
 case MDRD4=15
 sRet="4"
 case MDRD4<15
 sRet="5"
 else
 sRet=""
 endcond
 endif

return sRet
 }}

Let me know if this works for you.

- Beverly
 
                                                                                                	                                                
                                                         
                                                    
	                                        
                    
                    	
                            Posted : December 30, 2014 7:28 am		                    
						
                    	
                    
                

                
              

          


        
        
    
				
                            
                
                	                		
                                        
                        			
			                
					
		 mrooney
                        (@mrooney)
                        
                                                    
                        
                            Posts: 50                        
                        
                            Trusted Member                        
                            
		              
	                    
                    
                

                
                	
                         Topic starter
	                         
                    	
							                        
                                            
                    
                        Hi Beverly,
The CKD stage is showing as blank in the data display, but there are no MEL errors. I've double checked that the pt should have a CDK stage. Also, I've checked that the MEL expression is setup properly. I'll keep working on this. We're so close! 
Thanks,

Mike
                                                                                                	                                                
                                                         
                                                    
	                                        
                    
                    	
                            Posted : December 30, 2014 8:11 am		                    
						
                    	
                    
                

                
              

          


        
        
    
				
                            
                
                	                		
                                        
                        			
			                
					
		 blackmanb
                        (@blackmanb)
                        
                                                    
                        
                            Posts: 268                        
                        
                            Reputable Member                        
                            
		                  
	                    
                    
                

                
                	
                                                 
                    	
							                        
                                            
                    
                        

Try uncommenting the case statements to use the TRUNCATE (if you have not done so)

case MDRD4==60 // TRUNCATE(MDRD4, 0)==60

to

case TRUNCATE(MDRD4, 0)==60

... etc

also, I am never quite sure if I should use ==60   or  =60 when doing numeric comparisons,

and lastly - you might have to do debugging to see what the value of MDRD4 is,

so throw in a userok() statement like this:
After this line

MDRD4 = obsCalc
put

userok(" OBSANY(Creatinine) = " + OBSANY("Creatinine")

+ HRET +  "obsval = " + obsval

+ HRET + "MDRD4 = " + MDRDR

+ HRET + "TRUNC = " + TRUNCATE(MDRD4,0)

)
See what values you are getting, so you know why it is not being matched by the cond...endcond block.
- Beverly

                                                                                                	                                                
                                                         
                                                    
	                                        
                    
                    	
                            Posted : December 30, 2014 10:28 am



        
            
                
                    Page 1 / 2                
				                
				                    
						Next 
                    
				            
        
		
		        
            
				            
				                    
                         Forum Jump:
                        
                        
                    
								
														                        
                              Previous Topic
                            Next Topic


		
		





    
         Share:
        
        
						            
				                    
                        
                    
				            
			            
				                    
                        
                    
				            
						        
        
    
	

			        
            
                
                Forum Information
            
            
                
				                    
                        Recent Posts
				                    
                        Unread Posts
				                     Tags
            
        
        
			
			                
                    
                        
                            
                            24
                            Forums
                        
                        
                            
                            9,940
                            Topics
                        
                        
                            
                            39.9 K
                            Posts
                        
                        
                            
                            0
                            Online
                        
                        
                            
                            6,470
                            Members
                        
                    
                
			
            
                
                    
					Our newest member: Erin Kistner                
				                    
                        
						Latest Post: Register for Thrive, Austin: October 28-30, 2024 --ONE WEEK LEFT !
                    
				            

            
                
                    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 version 2.4.0



	
				
                    

                        © Community Healthcare Users Group  2024  |  Contact Us

                        Twitter
Facebook
Instagram
Youtube
LinkedIn