Divide Total Row

[proctors]

I need to take the Sum of one total and divide it by the other, but it ends up blank. I need 412.8 / 146.25 = 2.82

Expression for weighted is: Sum(Total [Sum wRVU in FY for each code])/SUM( Total [Adjustment if CPT Not Hourly])

CPT Code	# of units billed in FY	Adjustment if CPT Not Hourly	wRVU	Sum wRVU in FY for each code	Weighted average wRVU per unit billed
90791	4	4.00	3.00	12.0
90832	3	1.50	1.50	4.5
90834	5	3.75	2.00	10.0
90837	2	0.40	3.00	6.0
96150	236	35.40	0.50	118.0
96151	131	19.65	0.48	62.9
96152	295	44.25	0.46	135.7
96154	121	18.15	0.45	54.5
96155	21	3.15	0.44	9.2
NOCHG	16	16.00	0.00	0.0
Total	834	146.25	11.83	412.8	0.00

[Anil_Babu_Samineni]

What formula used for?

[Siva_Sankar]

Use the expression to get your expected output sum([Sum wRVU in FY for each code])/sum([Adjustment if CPT Not Hourly]).

I got your expected answer, refer the screenshot and attached qlikview file.

[shiveshsingh]

Hi

PFA

[shiveshsingh]

[proctors]

I'm getting a bad field name error. I'll post the file. (repost with SA off)

[proctors]

Still getting different number. See file I attached to my earlier post.

[sunny_talwar]

Please remove the section access from the attached file.

[proctors]

Sorry, just reposted above.

[sunny_talwar · Accepted solution]

May be this

Round(Sum(Aggr(Sum([Charge Qty])*(Sum([RVU WORK])/Sum([Charge Qty])), [CPT Code])), 0.1)/

Round(Sum(Aggr(IF([CPT Code]='90837', (Sum([Charge Qty]*0.2)),

IF([CPT Code]='90832', (Sum([Charge Qty]*0.5)),

IF([CPT Code]='90834', (Sum([Charge Qty]*0.75)),

IF([CPT Code]='96150', (Sum([Charge Qty]*0.15)),

IF([CPT Code]='96151', (Sum([Charge Qty]*0.15)),

IF([CPT Code]='96152', (Sum([Charge Qty]*0.15)),

IF([CPT Code]='96153', (Sum([Charge Qty]*0.15)),

IF([CPT Code]='96154', (Sum([Charge Qty]*0.15)),

IF([CPT Code]='96155', (Sum([Charge Qty]*0.15)), Sum([Charge Qty])))))))))), [CPT Code])), 0.01)