## Transform annual data into monthly cumulative data

Use this forum to discuss any issues relating to Systems Dynamics and Systems Thinking.
Priscila
Senior Member
Posts: 51
Joined: Thu Aug 25, 2016 1:11 pm
Vensim version: PRO

### Re: Transform annual data into monthly cumulative data

Yes, but from this variable I need to find the maximum value that another variable reaches during the month. This new variable must compare the value at time = 1 with the value at time = 0 and so on, always providing the maximum value.
Posts: 3951
Joined: Wed Mar 05, 2003 3:10 am

### Re: Transform annual data into monthly cumulative data

You already have all you need.

Code: Select all

``maximum value in month = SAMPLE IF TRUE ( new month trigger = 1 :OR: maximum value in month < YOUR LEVEL , YOUR LEVEL , YOUR LEVEL )``
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Priscila
Senior Member
Posts: 51
Joined: Thu Aug 25, 2016 1:11 pm
Vensim version: PRO

### Re: Transform annual data into monthly cumulative data

Problem solved.
Thank you.
Priscila
Senior Member
Posts: 51
Joined: Thu Aug 25, 2016 1:11 pm
Vensim version: PRO

### Re: Transform annual data into monthly cumulative data

Sorry for the nuisance again, but there is some function that takes values ​​over time for a given variable and provides the mean, for example:

variable X = 2,4,3,5,2,2
desired variable = 0,3,0,4,0,2
In this case the average of the variable X is calculated every two time intervals and presented.

Thank you once again.