Problem Note 48726: When using multiple nested formulas, the validator reports the formula to be incorrect
 |  |  |  |
When a formula is entered in a Microsoft Excel read-only report, a simple function, such as the following, will pass the validator and resolve in the spreadsheet:
=fmValue("A18000", "TIME", fmCode("TIME", "TIME", 2))
If you add another nested formula (for example, take the prior formula and add it to itself as shown below), the validator might fail the formula:
= fmValue("A18000", "TIME", fmCode("TIME", "TIME", 2)) +
fmValue("A18000", "TIME", fmCode("TIME", "TIME", 2))
If the formula fails, an error similar to the following might occur:
Member code "TIME" is not valid for hierarchy Account - Reporting and Planning.
As a result, you are prevented from saving the formula.
To obtain a fix for this issue, contact SAS Technical Support.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Financial Management | Microsoft Windows XP Professional | 9.3 TS1M2 | |
| Windows 7 Enterprise 32 bit | 9.3 TS1M2 | |||
| Windows 7 Enterprise x64 | 9.3 TS1M2 | |||
| Windows 7 Home Premium 32 bit | 9.3 TS1M2 | |||
| Windows 7 Home Premium x64 | 9.3 TS1M2 | |||
| Windows 7 Professional 32 bit | 9.3 TS1M2 | |||
| Windows 7 Professional x64 | 9.3 TS1M2 | |||
| Windows 7 Ultimate 32 bit | 9.3 TS1M2 | |||
| Windows 7 Ultimate x64 | 9.3 TS1M2 | |||
| Windows Vista | 9.3 TS1M2 | |||
Using two or more nested formulas causes the editor to report the formula to be incorrect and prevents the formula from being saved.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2020-02-25 10:41:09 |
| Date Created: | 2012-12-17 16:11:25 |