Performance
TEXTLIST used
TEXTLIST builds long text values across many cells, so keep it to small lists and small modules, or use a boolean or a count instead.
What MaxCheck detects
The TEXTLIST function or the TEXTLIST: summary in a reference.
Why it hurts
TEXTLIST builds long text values across many cells. It is memory-heavy and slow to recalculate.
Example
Taken from the rule's own test cases: formulas it must flag, and formulas it must not.
WarningFlags this(function)
TEXTLIST(Names, ", ", Products)
Fine (a name that contains the word)
'Textlist Output' & Textlist Flag
How to fix
Keep TEXTLIST to small lists and small modules, or replace it with a boolean or count where a list of names isn't needed.
- Severity
- WarningCounts toward the area score.
- Area
- Performance
- Runs in
- Basic and full check
- Rule ID
- P_TEXTLIST
- Version
- Rule 1.0.0, rule set 1.4.0
- Planual
- 2.02-11 Avoid using TEXTLIST()on Anaplan's Formulas page
Does your model do this?
Upload the line-items blueprint. This rule runs in the basic check, in your browser, with no email.