Hi all,
One of the Date columns in my Active form displays #NAME? error when opened in TM1Web while it works fine in Perspectives.
Here is the formula which drives the column
=IFERROR(EOMONTH(B29&"/1/"&C29,0),"")
I read that IFERROR formula shows error in TM1Web so I tried removing it by keeping it:
=EOMONTH(B29&"/1/"&C29,0)
Still get the same error.
Please help.
Thanks in advance.
TM1 Web- #NAME? error in 1 column
-
- Posts: 12
- Joined: Wed Jun 27, 2018 4:57 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: Excel2016
- 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: TM1 Web- #NAME? error in 1 column
Have a look at the Excel Functions that are supported in TM1Web - the two you are using are not supported AFAIK.
-
- MVP
- Posts: 3118
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: TM1 Web- #NAME? error in 1 column
Hello,
Replace your EOMONTH with DATE with regular numeric arguments. In Excel you can get the last day of a month by asking for day 0 of ‘month + 1’. Not 100% sure if that works in TM1 Web too. If not there are alternatives (e.g. a VLOOKUP in Excel or having an attribute in TM1).
IFERROR can be replaced with IF( ISERROR( ... if it’s not supported in TM1Web.
Replace your EOMONTH with DATE with regular numeric arguments. In Excel you can get the last day of a month by asking for day 0 of ‘month + 1’. Not 100% sure if that works in TM1 Web too. If not there are alternatives (e.g. a VLOOKUP in Excel or having an attribute in TM1).
IFERROR can be replaced with IF( ISERROR( ... if it’s not supported in TM1Web.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 12
- Joined: Wed Jun 27, 2018 4:57 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: Excel2016
Re: TM1 Web- #NAME? error in 1 column
Thank you Wim Gielis and gtonkin for your reply.
IF(ISERROR....) worked for me and I calculated the End date of the month by the old way in Excel.
Thanks.
IF(ISERROR....) worked for me and I calculated the End date of the month by the old way in Excel.
Thanks.