Get the Total value from another module

Atz1234

Hi everyone. i want to create a new module where all the total of Amount Drawdown in another module will reflect.

if the below total of Amount Drawdown is 2B

how can i insert this total in my new module.

i use this formula but it doesnt work.

'REP04 CB Loan'.Amount Drawdown[SELECT: Drawdown.Total Drawdown]

Accepted answers

AjayM

If the 'Drawdown' list has 'Total Drawdown' set as top level item, you shouldn't be receiving the "invalid formula….does not have a built-in top level" error. By the way, in your 'Test' module, if time dimension is set to 'Not Applicable', please add '[select: time.all periods]' to the formula. I understand REP06 has time dimension and yet the summary is not coming through.

It sounds pretty straight forward to me, but something is amiss. Would you mind sharing the configure tab of 'drawdown' list?

All comments

AjayM

If 'Total Drawdown' is top level of your list, and since the summary is ON in REP04, you shouldn't even be needing select function. With or without it, you should be getting the total value in REP06.

Are you getting 0 after submitting the formula?

Atz1234

Hi @AjayM thank you for your reply. yes Total Drawdown is a top level in my list.

I tried to add only this in formula, 'REP04 CB Loan'.Amount Drawdown, but it gives me an error.

i tried to add the list in Applies To and no error receive. but i'm not quite sure why there is no data appears.

AjayM

Quick Links

Can you help?

Unanswered questions

Error on Level 2 Sprint 1 1.3.4.2 Update SYS06 Country Details Module
not sure what I'm doing wrong here. Region List is a flat list as well. Any help would be appreciated
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385