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

[proctors]

Works. What did you do?!

[sunny_talwar]

Used Sum(Aggr()) to get the totals Sum of rows in pivot tables ‒ QlikView and used original expressions instead of column reference as they are not available within aggr function

[qlik4asif]

Can't we use Column(2)/Column(4)

taking ur original post as reference