How can I sum the value by list value

alexlee

Hi All,

 

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

 

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])

thanks

 

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

i hope it helps

cheers

Alex