Forum Discussion
Calculation Group format string expression mixing numbers and percentages help
The problem is that I want to get the Matrix and Table to recognise a figure as either a Number or a Percentage in one column rather than having to see it in 2 columns. For example. The matrix v...
See main column headings from spreadsheet
| KPI Index | Sort Order | Service | Provider | KPI Summary | Number or Percentage | Polarity | Date | Year & Qtr | Actual | Target | Target Agreed |
| 22 | 9 | Service "C" | Provider "C" | Length of Time in Treatment >26 week | No. | Lower is better | 30/06/2021 | 2021/22 Q1 | 21 | 26 | 26 |
| 22 | 10 | Service "C" | Provider "C" | Length of Time in Treatment >26 week | No. | Lower is better | 30/09/2021 | 2021/22 Q2 | 22 | 26 | 26 |
| 22 | 11 | Service "C" | Provider "C" | Length of Time in Treatment >26 week | No. | Lower is better | 31/12/2021 | 2021/22 Q3 | 18 | 26 | 26 |
| 22 | 12 | Service "C" | Provider "C" | Length of Time in Treatment >26 week | No. | Lower is better | 31/03/2022 | 2021/22 Q4 | 18 | 26 | 26 |
| 28 | 9 | Service "C" | Provider "C" | Conversion Rate | % | Higher is better | 30/06/2021 | 2021/22 Q1 | 20.36% | 0.75 | 75% |
| 28 | 10 | Service "C" | Provider "C" | Conversion Rate | % | Higher is better | 30/09/2021 | 2021/22 Q2 | 37.88% | 0.75 | 75% |
| 28 | 11 | Service "C" | Provider "C" | Conversion Rate | % | Higher is better | 31/12/2021 | 2021/22 Q3 | 89.75% | 0.75 | 75% |
| 28 | 12 | Service "C" | Provider "C" | Conversion Rate | % | Higher is better | 31/03/2022 | 2021/22 Q4 | 57.97% | 0.75 | 75% |