Problem Note 62869: Large values aggregate with rounding errors over filter hierarchies
 |  |  |  |  |
In SAS® Risk and Finance Workbench, large values aggregate with rounding errors over filter hierarchies. For example, values such as 10,000,099 for two sub-entities aggregate correctly to 20,000,198.00 for the parent entity. But values such as 100,000,099 for two sub-entities aggregate with rounding errors to 200,000,192.00 for the parent entity. The aggregation is performed correctly, without the rounding errors, to 200,000,198.00 if the filter hierarchy is on the Y axis.
There are no errors or warnings.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Risk and Finance Workbench | Microsoft® Windows® for x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 |
| Linux for x64 | 2.3 | 3.2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
A fix for this issue for SAS Risk and Finance Workbench 3.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C5N.html#62869A fix for this issue for SAS Risk and Finance Workbench 2.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A4G.html#62869
In SAS® Risk and Finance Workbench, large values such as 100,000,099 aggregate with rounding errors over filter hierarchies. This issue does not occur when you set the filter hierarchy to the Y axis.
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Analytics ==> Financial Analysis |
| Date Modified: | 2018-09-18 09:03:52 |
| Date Created: | 2018-09-05 20:27:53 |