Need help

Hi ,

It would be easy to simulate and propose some solution if we have some sample data handy in a file.

try this,

- Flag those apartment where is there is come movements like moveout/move in- you probably know the logic , i think you can use ausug date , also check and einzug is >= ausug for the same apartment. this way you will get 2 record one where someone moveout and 2nd where someone moved in.

- use EARLIER function or play with Current month/ previous month ( if you know) to get value from previous month and current .

- find the different beween previoud and current rate

- filter  where Difference <>0

it is not straight forward , but really have to spend time and change to logic to get the desire result.

share data if possible so i could try something at my end.

Good luck !

SS