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