Hi Ruby and welcome to the forum.
Within a single model calculated fields have to work with data from the same record - i.e. across for the row.
Assuming that your example is from the Table extracted, if your Field 1 is from an APPEND template of some sort (not the DETAIL template) then you can likely make the field fill in the table based on the value of the previous record. That should make the calculation work for you.
If the field is from the detail record that will not work. (This seems unlikely but I am including it just in case).
In that situation the most common approach would be to extract what you can and export it to a new file. Then use that file with another model and do as suggested above in order to fill the field.
Here is the relevant section of the Help file that explains the purpose of the "Copy from previous record" option.
Many reports are designed so that duplicate field values do not repeat down the page. When Monarch extracts the data from the report and builds a database table, it does not automatically duplicate these values, leaving empty cells throughout the field.
If that does not lead you to a solution let us know and we can seek an alternative approach.
I suspect that if the field is blank in some rows it is because it's been trapped as Detail instead of as Append.
The best way to think of the data when you are in Monarch is to view it as a database table, since that's exactly what it is. The rows are independent of one another, unlike Excel where you can make a row affect another.
The best way to think of the data when you are in Monarch is to view it as a database table, since that's exactly what it is. The rows are independent of one another, unlike Excel where you can make a row affect another.[/quote]
What Nick said.
Monarch and Excel together can make a very powerful solution to most data working challenges when you a familiar with which strengths each bring to the game.
You may find the observations at [URL="http://www.********************"]www.********************[/URL] help to provide a productive perspective - and more.