cancel
Showing results for 
Search instead for 
Did you mean: 

how can i get cumulative %

former_member196948
Participant
0 Kudos

Hi All,

I have a query How can i get CUMULATIVE  VALUE in this % age format" I am using 3.1

Eg:

Code CategoriesTotal Potential Cap Leakage% of TotalCumulative %
0100-0999 Series Codes (Rev Codes)$244,509.5351.31%51.31%
A0000 to Z9999 (HCPCs-All Alpha Codes)$129,393.0527.15%78.47%
99000-99799 Series Codes (E/M Codes)$53,945.8411.32%89.79%
70000 Series Codes (Radiology)$22,164.414.65%94.44%
80000 Series Codes (Lab)$12,211.442.56%97.00%
10000 through 69999 Series Codes (Surgery and Medicine)$8,595.351.80%98.80%
90100-90999 Series$5,669.021.19%99.99%
99800-99899 (CHDP Services)$25.840.01%100.00%
00100-01999 Series Codes (Anesthesia)$0.000.00%100.00%
99900-99999 Series Codes (Psych)$0.000.00%100.00%

Waiting for reply!!!!

Thanks in Advance

Ranjeet

Accepted Solutions (1)

Accepted Solutions (1)

arijit_das
Active Contributor
0 Kudos

v_Cumulative% =RunningSum(Percentage([Total Potential Cap Leakage]))

former_member196948
Participant
0 Kudos

Thanks Arijit and Ganapathy

It's working fine

Answers (1)

Answers (1)

former_member221192
Participant
0 Kudos

try with running sum