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

Seemlingly simple calculation

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

4 Posts

2 Users

0 Reactions

59 Views

RSS

Scott Forest

(@sforest)

Posts: 527

Honorable Member

Topic starter

{ IF DOCUMENT.Z1ST_LEVEL <> "" AND DOCUMENT.Z2ND_LEVEL == "" AND DOCUMENT.Z3RD_LEVEL == "" AND DOCUMENT.Z4TH_LEVEL == "" AND DOCUMENT.Z1ST_LEVEL_LATERALITY <> "bilateral" THEN DOCUMENT.CONTRAST_VOLUME_CALC = DOCUMENT.CONTRAST_VOLUME + DOCUMENT.STEROID_VOLUME_CALC = DOCUMENT.STEROID_VOLUME + DOCUMENT.SPINAL_AN_VOLUME_CALC = DOCUMENT.SPINAL_AN_VOLUME ELSE IF DOCUMENT.Z1ST_LEVEL <> "" AND DOCUMENT.Z2ND_LEVEL == "" AND DOCUMENT.Z3RD_LEVEL == "" AND DOCUMENT.Z4TH_LEVEL == "" AND DOCUMENT.Z1ST_LEVEL_LATERALITY == "bilateral" THEN DOCUMENT.CONTRAST_VOLUME_CALC = STR(VAL(DOCUMENT.CONTRAST_VOLUME)/2) + DOCUMENT.STEROID_VOLUME_CALC = STR(VAL(DOCUMENT.STEROID_VOLUME)/2) + DOCUMENT.SPINAL_AN_VOLUME_CALC = STR(VAL(DOCUMENT.SPINAL_AN_VOLUME)/2) ELSE "" ENDIF ENDIF }

I cannot get this code to work, it keeps coming up with 0 for the DOCUMENT.CONTRAST_VOLUME_CALC and everything else is blank. thoughts?

Posted : January 18, 2018 6:23 am

caswelljm

(@caswelljm)

Posts: 80

Trusted Member

Good Morning,

Just a quick look over, my guess is the error is caused by having a statement where: x=y + x =y

If you want to set 2 documents to a value just add it to the next line.

document.doc1 = value
document.doc2 = value2

It's always variable to be set followed by an = then any calculations you want.
document.doc3 = (1+2+3)/4

Try the code below. Let me know if this works, if not I can take a deeper look.

-James

{
IF DOCUMENT.Z1ST_LEVEL "" AND DOCUMENT.Z2ND_LEVEL == "" AND DOCUMENT.Z3RD_LEVEL == "" AND DOCUMENT.Z4TH_LEVEL == "" AND
DOCUMENT.Z1ST_LEVEL_LATERALITY "bilateral"
THEN
DOCUMENT.CONTRAST_VOLUME_CALC = DOCUMENT.CONTRAST_VOLUME
DOCUMENT.STEROID_VOLUME_CALC = DOCUMENT.STEROID_VOLUME
DOCUMENT.SPINAL_AN_VOLUME_CALC = DOCUMENT.SPINAL_AN_VOLUME
ELSE
IF DOCUMENT.Z1ST_LEVEL "" AND DOCUMENT.Z2ND_LEVEL == "" AND DOCUMENT.Z3RD_LEVEL == "" AND DOCUMENT.Z4TH_LEVEL == "" AND
DOCUMENT.Z1ST_LEVEL_LATERALITY == "bilateral"
THEN
DOCUMENT.CONTRAST_VOLUME_CALC = STR(VAL(DOCUMENT.CONTRAST_VOLUME)/2)
DOCUMENT.STEROID_VOLUME_CALC = STR(VAL(DOCUMENT.STEROID_VOLUME)/2)
DOCUMENT.SPINAL_AN_VOLUME_CALC = STR(VAL(DOCUMENT.SPINAL_AN_VOLUME)/2)
ELSE ""
ENDIF
ENDIF
}

Posted : January 18, 2018 6:53 am

Scott Forest

(@sforest)

Posts: 527

Honorable Member

Topic starter

figured it would be something simple, thank you for the explanation as to why as well, however the the ELSE IF... part of the statement isn't taking, it keeps inputting the first half of the statement. Thoughts on that?

Posted : January 18, 2018 7:56 am

Scott Forest

(@sforest)

Posts: 527

Honorable Member

Topic starter

wait, nevermind, that was my fault. thank you again

Posted : January 18, 2018 8:00 am

Share:

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