This item has been identified as an outstanding known issue.
Issue
z = TEXTLIST(x, y, n, [d])
Syntax taken from Anapedia
When using TEXTLIST formula and all source cells ("x" in above formula) are blank, the resulting cell using the 2 formulas below on "z" will have the following characteristic:
- LENGTH(z) = 0
- ISBLANK(z) = FALSE (Note: ISNOTBLANK will return TRUE)
As above, there's a discrepancy between the two.
LENGTH tells z has no value while ISBLANK tells z is NOT empty.
Workaround
There's several ways to workaround this issue:
- Surround the TEXTLIST line item with TRIM()
- Use LENGTH instead of ISBLANK or ISNOTBLANK. ie, to simulate ISBLANK insert formula: LENGTH(z) == 0
If this workaround is not suitable in your use case, please contact Support at support@anaplan.com.
---
Internal Reference: CALC-2247
