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 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!
