on 01-04-2014 9:56 AM
Hi All,
I have a query How can i get CUMULATIVE VALUE in this % age format" I am using 3.1
Eg:
Code Categories | Total Potential Cap Leakage | % of Total | Cumulative % |
0100-0999 Series Codes (Rev Codes) | $244,509.53 | 51.31% | 51.31% |
A0000 to Z9999 (HCPCs-All Alpha Codes) | $129,393.05 | 27.15% | 78.47% |
99000-99799 Series Codes (E/M Codes) | $53,945.84 | 11.32% | 89.79% |
70000 Series Codes (Radiology) | $22,164.41 | 4.65% | 94.44% |
80000 Series Codes (Lab) | $12,211.44 | 2.56% | 97.00% |
10000 through 69999 Series Codes (Surgery and Medicine) | $8,595.35 | 1.80% | 98.80% |
90100-90999 Series | $5,669.02 | 1.19% | 99.99% |
99800-99899 (CHDP Services) | $25.84 | 0.01% | 100.00% |
00100-01999 Series Codes (Anesthesia) | $0.00 | 0.00% | 100.00% |
99900-99999 Series Codes (Psych) | $0.00 | 0.00% | 100.00% |
Waiting for reply!!!!
Thanks in Advance
Ranjeet
v_Cumulative% =RunningSum(Percentage([Total Potential Cap Leakage]))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
try with running sum
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.