cumulative pecentage doesn't work

[Marie201931]

I have the following code to do the snapshot percentage and it worked.

(count({< [Adopted in 15 days] = {'Yes'} >} [Adopted in 15 days]) + count({< [Adopted over 15 days] = {'Yes'} >} [Adopted over 15 days]) ) /(count([RPA number]) - count({< [Pending for TF] = {'Yes'} >} [Pending for TF]) )

Now I want to do the cumulative percentage, I tried two sets of code. They didn't work.

=rangesum(above((count({< [Adopted in 15 days] = {'Yes'} >} [Adopted in 15 days]) + count({< [Adopted over 15 days] = {'Yes'} >} [Adopted over 15 days]),0,RowNo(total) )) /RangeSum(above((count([RPA number]) - count({< [Pending for TF] = {'Yes'} >} [Pending for TF])),0,RowNo(total)))

=rangesum(above((count({< [Adopted in 15 days] = {'Yes'} >} [Adopted in 15 days]) + count({< [Adopted over 15 days] = {'Yes'} >} [Adopted over 15 days])) )) /RangeSum(above((count([RPA number]) - count({< [Pending for TF] = {'Yes'} >} [Pending for TF]))))

Thanks for your help!

[fosuzuki]

It seems that you had a missing parenthesis in the first expression. Try this:

rangesum(above((count({< [Adopted in 15 days] = {'Yes'} >} [Adopted in 15 days]) + count({< [Adopted over 15 days] = {'Yes'} >} [Adopted over 15 days])),0,RowNo(total) )) /RangeSum(above((count([RPA number]) - count({< [Pending for TF] = {'Yes'} >} [Pending for TF])),0,RowNo(total)))