TM1 Web- #NAME? error in 1 column

Post Reply
cognos4321
Posts: 12
Joined: Wed Jun 27, 2018 4:57 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel2016

TM1 Web- #NAME? error in 1 column

Post by cognos4321 »

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.
User avatar
gtonkin
MVP
Posts: 1192
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

Post by gtonkin »

Have a look at the Excel Functions that are supported in TM1Web - the two you are using are not supported AFAIK.
Wim Gielis
MVP
Posts: 3103
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

Post by Wim Gielis »

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.
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
cognos4321
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

Post by cognos4321 »

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.
Post Reply