Problem Note 71161: The CDAGet functions return an unknown value (#VALUE!) in place of the expected value and surface the message "System.NullReferenceException..."
 |  |  |  |  |
When you use SAS® Financial Management 5.62 in SAS® 9.4M8 (TS1M8), the CDAGet functions can return an unknown result such as (#VALUE!) instead of the expected zero value.
The image below illustrates this situation. The left side shows the read-only table and the crossing values equal to zero; the right side shows the CDAGet function with the unknown result (#VALUE!) for the same crossing visible in the table:
In this scenario, SAS Financial Management Excel Add-In log contains the following error message:
Cause
This issue occurs in SAS Financial Management 5.62. It occurs only when all the CDAGet functions in the report should return a value equal to zero.
Workaround
A possible workaround is to add a new CDAGet function with a value not equal to zero in your report. After you add the new function, the expected behavior resumes: the CDAGet functions return the same values as the read-only table:
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 Financial Management | Microsoft® Windows® for x64 | 5.62 | 9.4 TS1M8 | ||
| 64-bit Enabled AIX | 5.62 | 9.4 TS1M8 | ||||
| 64-bit Enabled Solaris | 5.62 | 9.4 TS1M8 | ||||
| Linux for x64 | 5.62 | 9.4 TS1M8 | ||||