Problem aggregating values from timscale day to month
Hi all, I have problems aggregating values from a module dimensioned with day, to a module dimensioned with month. I am doing rent calculations in a module by DAY time scale. When I try to aggregate this to a monthly calc module it does not work. No values are pulled over. It is the last part of the formula below that does not work, where I sum on a line item in the other module that has the format month and time scale DAY (showing the month the day belongs to). For some reason, this sum does not work. Does anyone know the issue?
Month line item from the daily rent module;