How can I sum the value by list value

alexlee
alexlee
in Modeling

Hi All,

 

I have create a module which show the amount in 'Revenue' column

alexlee_0-1635930107207.png

 

How can I sum the value and put in the following module?

I have tried the following formula but the result can't be shown

(test version.Revenue[SUM: test version.Test])

alexlee_1-1635930116185.png

thanks

 

Tagged:

Answers

  • AlejandroGomez
    AlejandroGomez

    Hi @alexlee 

     

    Try this:

    1. create a new line item in your source module that checks if your "test" line item is "PY actual". If PY Actuals then Revenue else 0

    2. in your target module, refer to the new line item and select all time periods

     

    Here you have an example

    AlejandroGomez_0-1635936742605.png

    i hope it helps

    cheers

    Alex 

Categories