Welcome to the NEW Community Healthcare User Group ( the new CHUG)— your ultimate destination for insights and discussions at the intersection of healthcare and technology.

Please scroll to the bottom for “Centricity” related topics from the previous forum.

Notifications

Clear all

Grand Total

Trading Post

Last Post by Anonymous 1 second ago

1 Posts

1 Users

0 Reactions

76 Views

RSS

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

Topic starter

I created the formula below to calculate RVUs in a crystal report I made recently and this works great but I cannot seem to get a grand total to work in the report footer. Any suggestions?

Stacey LaGrange
Software Developer/Analyst
St. Mary's Health System
[email protected]
(207) 777-8410

If {ORDERS.CODE} = "99201" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.48

Else If {ORDERS.CODE} = "99202" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.93

Else If {ORDERS.CODE} = "99203" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.42

Else If {ORDERS.CODE} = "99204" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 2.43

Else If {ORDERS.CODE} = "99205" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 3.17

Else If {ORDERS.CODE} = "99211" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.18

Else If {ORDERS.CODE} = "99212" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.48

Else If {ORDERS.CODE} = "99213" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.97

Else If {ORDERS.CODE} = "99214" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.5

Else If {ORDERS.CODE} = "99215" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 2.11

Else If {ORDERS.CODE} = "99391" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.02

Else If {ORDERS.CODE} = "99392" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.19

Else If {ORDERS.CODE} = "99393" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.19

Else If {ORDERS.CODE} = "99394" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.36

Else If {ORDERS.CODE} = "99395" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.36

Else If {ORDERS.CODE} = "99396" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.53

Else If {ORDERS.CODE} = "99397" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.71

Else If {ORDERS.CODE} = "G0101" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.45

Else If {ORDERS.CODE} = "G0102" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.17

Else If {ORDERS.CODE} = "99406" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.24

Else If {ORDERS.CODE} = "99407" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.5

Else If {ORDERS.CODE} = "G0402" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.34

Else If {ORDERS.CODE} = "G0438" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 2.43

Else If {ORDERS.CODE} = "G0439" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.5

Else If {ORDERS.CODE} = "98925" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.45

Else If {ORDERS.CODE} = "98926" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.65

Else If {ORDERS.CODE} = "98927" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.87

Else If {ORDERS.CODE} = "98928" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.03

Else If {ORDERS.CODE} = "98929" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.19

Else If {ORDERS.CODE} = "10060" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.22

Else If {ORDERS.CODE} = "10061" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 2.45

Else If {ORDERS.CODE} = "57170" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.91

Else If {ORDERS.CODE} = "58300" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.01

Else If {ORDERS.CODE} = "69210" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.61

Else If {ORDERS.CODE} = "93000" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.17

Else If {ORDERS.CODE} = "G0403" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * .17

Else If {ORDERS.CODE} = "G0405" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * .17

Else If {ORDERS.CODE} = "17000" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.6

Else If {ORDERS.CODE} = "17110" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * .65

Else If {ORDERS.CODE} = "17111" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.92

Else If {ORDERS.CODE} = "11400" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.9

Else If {ORDERS.CODE} = "11401" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.28

Else If {ORDERS.CODE} = "11402" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.45

Else If {ORDERS.CODE} = "11420" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.03

Else If {ORDERS.CODE} = "11421" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.47

Else If {ORDERS.CODE} = "11422" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.68

Else If {ORDERS.CODE} = "11600" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.63

Else If {ORDERS.CODE} = "11601" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 2.07

Else If {ORDERS.CODE} = "11602" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 2.27

Else If {ORDERS.CODE} = "11620" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.64

Else If {ORDERS.CODE} = "11621" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 2.08

Else If {ORDERS.CODE} = "11622" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 2.41

Else If {ORDERS.CODE} = "11055" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.43

Else If {ORDERS.CODE} = "11056" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.61

Else If {ORDERS.CODE} = "11057" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.79

Else If {ORDERS.CODE} = "11100" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.81

Else If {ORDERS.CODE} = "11101" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.41

Else If {ORDERS.CODE} = "57452" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.5

Else If {ORDERS.CODE} = "57456" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.85

Else If {ORDERS.CODE} = "58110" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.77

Else If {ORDERS.CODE} = "20550" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.86

Else If {ORDERS.CODE} = "20552" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.86

Else If {ORDERS.CODE} = "20553" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.86

Else If {ORDERS.CODE} = "20600" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.66

Else If {ORDERS.CODE} = "20605" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.68

Else If {ORDERS.CODE} = "20610" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.79

Else If {ORDERS.CODE} = "20551" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.86

Else If {ORDERS.CODE} = "99241" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.64

Else If {ORDERS.CODE} = "99242" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.34

Else If {ORDERS.CODE} = "99243" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.88

Else If {ORDERS.CODE} = "99244" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 3.02

Else If {ORDERS.CODE} = "99245" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 3.77

Else If {ORDERS.CODE} = "99381" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.19

Else If {ORDERS.CODE} = "99382" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.36

Else If {ORDERS.CODE} = "99383" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.36

Else If {ORDERS.CODE} = "99384" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.53

Else If {ORDERS.CODE} = "99385" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.53

Else If {ORDERS.CODE} = "99386" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 1.88

Else If {ORDERS.CODE} = "99387" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 2.06

Else If {ORDERS.CODE} = "Q0091" Then

Count ({ORDERS.CODE}, {ORDERS.CODE}) * 0.37

Else

Posted : July 18, 2012 2:09 am

24 Forums
9,943 Topics
39.9 K Posts
8 Online
6,472 Members

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

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