Hi there
Have a bit of a strange situation with a SUBNM in my slicer.
It resolves to "#N/A", but if I hit F2 and enter in my Cell, it resolves properly.
The workbook formula I have is:
=SUBNM("payroll:Month";"Default";"Unspecified Month";"Description")
Always have to hit F2 and enter to get it so show "Unspecified month".
Any ideas?
Many thanks!
Regards
Chris
SUBNM - #N/A in Workbook
- gtonkin
- MVP
- Posts: 1199
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: SUBNM - #N/A in Workbook
Hi Chris, don't want to make assumptions that you are using Perspectives because your TM1 version is 9.5. Perspectives or PAfE?
Is the SUBNM hardcoded per your example or are there cell references, references to names etc?
If you set your separator to commas instead of semi-colons does it behave the same?
Is the SUBNM hardcoded per your example or are there cell references, references to names etc?
If you set your separator to commas instead of semi-colons does it behave the same?