TEXTLIST summary for line items with format set to Text

As Model Builder, I want to have additional choice - TEXTLIST - when selecting summary for line items formatted as Text.

When TEXTLIST is selected, summary should join/concatenate lower level data. Preferably, joining should be done using separator defined by user (as different appilcations may need comma, colon, dot, semicolon, pipe, newline or even something else). If user input cannot be supported, at least using drop-down and choosing from predefined options, in a similair way we can pick which line items should be used for Ratio summary for numbers, so we can choose "," (comma), but also "\n" (newline) or ",\n" (comma with newline).

This would compliment existing TEXTLIST() and [TEXTLIST:] functions, and be especially helpful for cases like:

  • escalation of comments inputted by users on lower levels, up in the hierarchy,
  • show which months were overriden/adjusted at quarterly/yearly overview (Time-summaries)
  • easily gather tags/flags assigned to individual items at Top Level
5 votes

New · Last Updated

Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!