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
0