Register

Text cells merged by TEXTLIST generates partially blank cell

julio.harada
Contributor

Text cells merged by TEXTLIST generates partially blank cell

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