Insert text on summary items

Hi all,

I am building a dashboard for the finance leads to comment on the Operational Variance for every chart of account. (see attached)

They need to comment on the Op. Var. for the current period, for the quarter and for the year.

In the table on top they see the figures.

I wanted to created a grid below to capture their comments, which is synced with the chart of account they select in the top table and which is showing the op var for that period/quarter/year.

Comment is a text-formatted line item and that is why inputting a comment on the quarter and the year does not work.

Does any one have an idea what I could build in order to be able to capture the comments also on quarter and on year?

Thansk for your input!

MOS_input_comments_on_quarter_and_year_74956.PNG

Accepted answers

All comments

LouiseBourgonjon

I think I found a solution.

I won't be able to capture the comments in one grid, but I will create 3 separte grids: one based on module with dimension period, one based on module with dimension quarter and the last one based on module with dimension year.

filip.sypniewski

Hi @LouiseBourgonjon,

I do think that it is the best approach in this case, else you will not be able to input comments on different levels of time dimension.

Kanishq17

@LouiseBourgonjon

Alternatively you can create a flat list of the periods you want to enter comments for, then enter comments against the flat list and the accounts dimension, then map those periods with time dimension in another module, then aggregate the comments using textlist

or your method also will work fine of creating 2 separate grids with different dimensions

rob_marshall

@Kanishq17 ,

Just a friendly reminder, using TextList() is not good for performance, instead, try using ANY or the others listed in this post.

Rob

Quick Links

Can you help?

Unanswered questions

Can Please explain the difference between a general list,a module,and action in Anaplan.
Can please explain why we create a general list ,a module,and Action ,and what purpose each one serves.🙂
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…