Problem Note 61776: When you attempt to validate an arithmetic operation that is in a worksheet, the validation might not yield the correct result
 |  |  |  |  |
In SAS® Risk and Finance Workbench, when you attempt to validate an arithmetic operation that is in a worksheet, the validation might not yield the correct result.
This issue occurs because of floating-point arithmetic, which yields results that are not rounded, and can cause the validation to yield the incorrect results. For example, the values to be summed in a spreadsheet formula might be 0.4, 0.5, and 0.1. In the validation, these values evaluate to the not-rounded value of 0.99999999. Instead, the validation should yield the value of 1.0.
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#61776A 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#61776| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Financial Analysis |
| Date Modified: | 2018-03-02 08:59:39 |
| Date Created: | 2018-01-31 09:34:54 |