Problem Note 64853: SAS® Visual Analytics returns incorrect results when multiple calculated items that use the Percentile operator are used in the same table
 |  |  |  |  |
SAS Visual Analytics might return incorrect results when multiple calculated items that use the Percentile operator are included in the same list table or a crosstab. For example, suppose that your report includes these two calculated data items:
- MPG Percentile is calculated as Percentile [_ForAll_] ('MPG'n, 90)
- MSRP Percentile is calculated as Percentile [_ForAll_] ('MSRP'n, 90)
The following display shows the MPG Percentile calculated item:
The correct value for MPG Percentile is 26 and the correct value for MSRP Percentile is 52,795. These values are displayed correctly when the calculated items are used in separate tables, as shown in the following display:
However, if you use both calculated items in the same list table or crosstab, then the values are incorrect. In the following display, MPG Percentile was added first to the list table, and then MSRP Percentile was added. Both values incorrectly show 26.
The workaround is to place each calculated item in a separate table.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics (on SAS Viya) | Cloud Foundry | 8.3.1 | 8.5 | Viya | Viya |
| Linux for x64 | 8.3.1 | 8.5 | Viya | Viya | ||
| Microsoft® Windows® for x64 | 8.3.1 | 8.5 | Viya | Viya | ||