Get the Total value from another module

ArthurAng
ArthurAng
edited October 28 in Modeling

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

image.png

how can i insert this total in my new module.

image.png

i use this formula but it doesnt work.

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

Best Answer

  • AjayM
    AjayM
    edited October 29 Answer ✓

    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?

    image.png

    image.png
    image.png

Answers

  • AjayM
    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?

  • ArthurAng
    ArthurAng
    edited October 29

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

    image.png

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

    image.png
    image.png

    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.

    image.png

Categories