I am creating a report but struggling with the formula.
There are two tables
- Rent Due
I want to update the rent due table based on the Tenancy.
In the Tenancy table there is a column known as End_Date and I want to update the Rent due table on every 1st of each month so it shows me which property rent is due for that month ( I already have a view about this)
However the issue I am struggling to write the formula in condition field in report which would give me this result .
I appreciate your help