Problem Note 64872: Formulas might be not evaluated and #NAME might appear in the worksheet cell when you change a worksheet filter in SAS® Risk and Finance Workbench
 |  |  |  |  |
When you change a worksheet filter in SAS Risk and Finance Workbench, the formula might be not evaluated and #NAME might appear in the worksheet cell.
This issue happens when cross-sheet formulas are defined in the worksheets.
To work around the issue, you must select the All category or close and reopen the worksheets to see the formula resolution.
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 | 3.1 | 9.4 TS1M5 | ||
| Linux for x64 | 3.1 | 9.4 TS1M5 | ||||
A fix for this issue for SAS Risk and Finance Workbench 3.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D4L.html#64872A 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#64872
When you change a worksheet filter in SAS Risk and Finance Workbench, the formula might be not evaluated and #NAME might appear in the worksheet cell. This issue happens when cross-sheet formulas are defined in the worksheets.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-10-08 15:03:56 |
| Date Created: | 2019-10-07 03:48:39 |