How can I sum the value by list value

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

Tags

Modeling

Calculation Functions

Accepted answers

All comments

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

Quick Links

Can you help?

Unanswered questions

Call Center Indodax
Hubungi Call Center INDODAX melalui +62822225789 WA atau email support@indodax.com.
How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…