Aggregation of Text Comments up a hierarchy using TEXTLIST

Highlighted
New Contributor

Aggregation of Text Comments up a hierarchy using TEXTLIST

End goal is to be able to enter and aggregate text formatted comments up a hierarchy.  Entry should be possible at each level, with prior results appended.

 

I feel like I should be able to use TEXTLIST in the Summary: Formula for the line item and have it roll up the hierarchy on its own.  I have not been able to figure out how.   Would I be able to edit at the higher levels is still an issue.   Not like its a numerical breakback.   Any ideas try or solutions would be appreciated.

 

My inelegant solution is a series of modules for each hierarchy level where I aggregate using textlist based off the comment and parents from lower level items.  

Unless there is a way to deliver different modules to a dashboard based on the hierarchy selection (not that I am aware of)  I would need to create entry dashboards for each level to map comments to hierarchy.

 

o3 comment.jpgo4 comment.jpg

 

5 REPLIES 5
Highlighted
Master Anaplanner/Community Boss

Re: Aggregation of Text Comments up a hierarchy using TEXTLIST

@JCFudali 

Interesting use-case.

When you aggregate comment text what is the expectation? Are you trying to count the number of comments?

If so, you can just use another line item that tests for blank or length and assign a zero or 1. Then sum them up.

 

Help us understand the requirement a little better and we'll get you to the finish line.


Jared Dolich
Highlighted
New Contributor

Re: Aggregation of Text Comments up a hierarchy using TEXTLIST

@JaredDolich 

End goal is to capture the full text of the comments related to forecast variances.  Comments could be captured at any level and users at multiple levels may need to make a comment.

 

As I indicated above I feel like I should be able to use textlist as a summary formula for the text based comment but I just don't think it works that way.  How and where does one enter a formula for a formula based sum?  Maybe my understanding of formula based sum is off.

 

 

 

Highlighted
Community Boss

Re: Aggregation of Text Comments up a hierarchy using TEXTLIST

No, you cannot input text on multiple levels like breakback.
I'm afraid your solution is the only one if you want user to be able to input comments at every level.


Nathan Rudman, Anaplan Model Builder
Highlighted
Master Anaplanner/Community Boss

Re: Aggregation of Text Comments up a hierarchy using TEXTLIST

@JCFudali 

 

We all know how much TEXTLISTs are bad to Hyperblock but if there is a requirement like this then this is the only way I can think of. Hence I second you that you need to have multiple modules of diff dimensions and then aggregate texts on lower levels of hierarchy

Highlighted
Valued Contributor

Re: Aggregation of Text Comments up a hierarchy using TEXTLIST

It is unfortunate that Anaplan currently can't aggregate text up a hierarchy/time.
This is a common and much-needed use case for finance- forecast and budget analysis. 
Users viewing the Quarterly results, for example, would like to know the qualitative information associated with the quantitative results.

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"