Dear.
I have created a pivot table with the following data:
Row: [AR day nbr] - gives me the day number of AR
Collumn: [Inv Year Month]
Measures:
=rangesum(above(Sum({<[Type]={'APP'},[Cash App Type]={'CASH'}>}[AR USD]*(-1))
/
sum({<[Type]={'INV'},[Rebill Indicator]={'Non Rebill'}>}total<[AR Year Month]>[AR USD]),0,RowNo()))
Result is:
AR ay Nbr | Inv Month | Feb 2017 |
-13 | | 3.0% |
-12 | | 4.3% |
-11 | | 5.3% |
-10 | | 6.4% |
-9 | | 6.8% |
-8 | | 8.2% |
-7 | | 8.5% |
-6 | | 13.3% |
-5 | | 17.3% |
-4 | | 20.4% |
-3 | | 24.3% |
-2 | | 28.0% |
-1 | | 28.4% |
0 | | 63.0% |
1 | | 64.6% |
2 | | 77.2% |
3 | | 81.8% |
4 | | 84.4% |
5 | | 85.6% |
74 | | 98.6% |
75 | | 98.6% |
76 | | 98.6% |
89 | | 98.6% |
90 | | 98.7% |
91 | | 98.7% |
93 | | 98.7% |
94 | | 98.7% |
95 | | 98.8% |
96 | | 98.7% |
97 | | 98.7% |
98 | | 98.7% |
99 | | 98.7% |
111 | | 98.9% |
112 | | 98.9% |
113 | | 98.9% |
114 | | 99.0% |
115 | | 99.0% |
116 | | 99.0% |
125 | | 99.1% |
Now I want to create a KPI where I can show in the KPI what the the day number is when hit the number >99%. For an example, in the example used above the KPI should show me 114.
Can you please help me?
Should this be an if function?
Thanks a lot.
Ugur