TM1 Forum

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.

Have a look at the Excel Functions that are supported in TM1Web - the two you are using are not supported AFAIK.

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.

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.