Problem Note 45281: A formula's value might be displayed as a pink cell in a SAS® Financial Management read-only report or data-entry form
 |  |  |  |
A formula's value might be displayed as a pink cell in a SAS Financial Management read-only report or data-entry form. This problem occurs if the formula uses the PROPERTY function and specifies a property value without quotation marks.
For example, this formula does not resolve correctly and is displayed as a pink cell:
IF(PROPERTY("TIME","Flag") =1, ["ANALYSIS"="Actual"],
["ANALYSIS"="FC"])
If you right-click the pink cell and select Tools ► Cell Information, the following error is displayed:
Query failed due to a formula operand not found.
Reporting formula on dimension type ANALYSIS executed to produce this
cell's value.
IF(PROPERTY("TIME","Flag") =1,
["ANALYSIS"="Actual"], ["ANALYSIS"="FC"])
To correct this problem, modify the formula and place the property value in quotation marks as shown below.
IF(PROPERTY("TIME","Flag") ="1", ["ANALYSIS"="Actual"],
["ANALYSIS"="FC"])
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Linux for x64 | 5.2_M1 | 9.2 TS2M0 | ||
| 64-bit Enabled Solaris | 5.2_M1 | 9.2 TS2M0 | ||||
| 64-bit Enabled AIX | 5.2_M1 | 9.2 TS2M0 | ||||
| Windows Vista for x64 | 5.2_M1 | 9.2 TS2M0 | ||||
| Windows Vista | 5.2_M1 | 9.2 TS2M0 | ||||
| Microsoft Windows XP Professional | 5.2_M1 | 9.2 TS2M0 | ||||
| Microsoft Windows Server 2008 for x64 | 5.2_M1 | 9.2 TS2M0 | ||||
| Microsoft Windows Server 2008 R2 for x64 | 5.2_M1 | 9.2 TS2M0 | ||||
| Microsoft Windows Server 2003 for x64 | 5.2_M1 | 9.2 TS2M0 | ||||
| Microsoft Windows Server 2003 Standard Edition | 5.2_M1 | 9.2 TS2M0 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 5.2_M1 | 9.2 TS2M0 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 5.2_M1 | 9.2 TS2M0 | ||||
| Microsoft® Windows® for x64 | 5.2_M1 | 9.2 TS2M0 | ||||
The query fails due to a missing formula operand in SAS Financial Management.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2012-01-06 09:21:11 |
| Date Created: | 2012-01-04 11:07:43 |