TM1 Web- #NAME? error in 1 column

Post Reply
cognos4321
Posts: 2
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 » Wed Jun 27, 2018 6:54 pm

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: 638
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: TM1 Web- #NAME? error in 1 column

Post by gtonkin » Wed Jun 27, 2018 7:04 pm

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: 1826
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: TM1 Web- #NAME? error in 1 column

Post by Wim Gielis » Thu Jun 28, 2018 12:17 am

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

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

cognos4321
Posts: 2
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 » Thu Jun 28, 2018 8:59 pm

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