but in this current data model I have two separate tables. The first containing worker dimensions including their monthly pre-income (this is static and does not change). The second containing the income they earn via the new job (it is a leather workshop that they work part time in so the current income would be the pre monthly income + whatever they earn from this - hence the addition in the 'Current Income' expression above) where they get paid per batch delivered. So in one month they might have four rows of data detailing the different batches they delivered and how much they got paid for it.
With this model I am struggling to create a Count(If statement work. Any suggestions or ideas would be much appreciated
The Pre Monthly Income = the 'Monthly Income' field. Unfortunately there are no dates that fall under 'Monthly Income'. It is just a figure that is collected via survey at the beginning of the project.
The Current Income = 'Monthly Income' + 'Remuneration (the idea is that these people continue earning there pre-income and that this job is a source of supplementary income.