Hi.
I have ingoing balance in January and I would like to recreate that for month ahead to be able to calculate each month against ingoing balance. The problem I face is that I would like to splitt it per Site and when I do that the report become not correct.
1. In my first picture I have all the balance in January and is splittet correct per site and I would like to recreate this on each month.
2. In my second picture I try to use total function and then it recreate on each month but with not correction proportions.
3. Do I need to create a variable?
sum({<Account= {"1451","14411","1431","1421","1452"},Month= {"<=$(=max({<Year={$(=Only(Year))}>} Month))"}>}$(Balance))
Regards Mikael