Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)))