How can I sum the value by list value

alexlee
Occasional Contributor

How can I sum the value by list value

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

 

1 REPLY 1
AlejandroGomez
Master Anaplanner/Community Boss

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