YTD (cumulative) data to MTD data

[ROHANPACH]

Hello experts

I have large data sets in a cumulative way like different files on YTD basis. So for example - multiple files for Jan YTD, Feb YTD and so on.

By Union tool I can make 1 file since the structure of all the files will be same. How do I get the data for individual months and probably automate this for future months as well? 

Request your help on this!

[RolandSchubert · Accepted solution]

Missed that step ... if only periods with amount != 0 are provided, you have to create these missing "empty" periods.

 

I added the first step, should work now as expected.  Give it a try.

[ROHANPACH]

@RolandSchubert Perfect! Many thanks!

[nlevinson]

why do you use isnull in the formula?