Many to one text merge

Hi,

In my FP&A model end-users can add comments(in text format) to a variance module that is dimensioned by the user list(among other dimensions).

How can I consolidate the comments so we can see comments from all users combined? I'm thinking we would have a secondary module not dimensioned by end user.

The main challenge is consolidating the text based comments from many to one.

Accepted answers

shubhamrawat

Hi,

I built a similar functionality in one of our models, using TEXTLIST() function.

Please see the screenprint below. You may find the attached link useful.

https://help.anaplan.com/textlist-c1e24970-400f-43af-95e7-b34a43253cdb

All comments

PulkitChawla

@michael.chefer - When you say consolidate, you mean putting all the comments from all the users into a single item?

michael.chefer

@PulkitChawla

Correct. Have any ideas? I haven't found any community posts that provide a solution.

shubhamrawat

Hi,

I built a similar functionality in one of our models, using TEXTLIST() function.

Please see the screenprint below. You may find the attached link useful.

https://help.anaplan.com/textlist-c1e24970-400f-43af-95e7-b34a43253cdb

PulkitChawla

@shubhamrawat - Just curious to know will there be any limit of comment items using textlist function? Like it can take how many comments separated by commas?

shubhamrawat

@PulkitChawla Function has a limit of 10k Characters, however, it works well in my scenario, as we have short comments only from 10 executives.

Quick Links

Can you help?

Unanswered questions

UX Filter
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?