TM1 Web- #NAME? error in 1 column

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

[gtonkin]

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

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

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