TM1 Tips & Tricks: Workarounds for Unsupported Excel Functions in TM1 Web
TM1 Tips & Tricks: Workarounds for Unsupported Excel Functions in TM1 Web

This is a guest blog post from Revelwood’s Nina Gordy.

Did you know there are a number of workarounds for unsupported Excel functions in TM1 Web?

Have you ever published a TM1 Web report, only to see repeating #NAME errors when you access the report online? These are typically caused by unsupported Excel functions. While TM1 Web does support most Excel functions, there are some that it does not. Here, I’ll demonstrate ways to work within these limitations by providing examples of workarounds for commonly-used unsupported Excel functions.

Function: ISBLANK

Description: Returns TRUE if the value is blank, FALSE otherwise

A B C D
1 Input Original Result Compatible with TM1 Web
2 ISBLANK(A2) TRUE IF(A2=””, TRUE, FALSE)

 

Function: ISERROR

Description: Returns TRUE if the value is any error value, FALSE otherwise

A B C D
1 Input Original Result Compatible with TM1 Web
2

IF(ISERROR(A2/A3), 0, A2/A3)

0.5 IF(A3=0, 0, A2/A3)

 

Function: ISEVEN

Description: Returns TRUE if the number is even, FALSE otherwise

A B C D
1 Input Original Result Compatible with TM1 Web
2 1

ISEVEN(A2)

FALSE IF(MOD(A2,2)=0, TRUE, FALSE)

 

Function: ISODD

Description: Returns TRUE if the number is odd, FALSE otherwise

A B C D
1 Input Original Result Compatible with TM1 Web
2 1

ISODD(A2)

TRUE IF(MOD(A2,2)=1, TRUE, FALSE)

 

Function: TRUNC

Description: Truncates a number to an integer

A B C D
1 Input Original Result Compatible with TM1 Web
2 1.75

TRUNC(A1,1)

1.7 ROUNDDOWN(A1,1)

 

IBM’s documentation on Excel functions that are not supported by TM1 Web can be found here.

IBM Planning Analytics is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help.  Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!


Never miss another post.

Sign Up for Our Newsletter.