Support #851
Components of net monthly income
100%
Description
Hi,
I have noticed some cases of individuals where the components of net monthly income (e.g. labour income, social benefits etc.) sum to less than the total net monthly income. Is this a known data issue? In some cases for example the individual is employed but no labour income is recorded which suggests it may be a reporting error in the components?
Thanks very much,
Olly
Updated by Stephanie Auty over 6 years ago
- Category changed from Data inconsistency to Income
- Status changed from New to In Progress
- Assignee changed from Alita Nandi to Stephanie Auty
- % Done changed from 0 to 10
- Private changed from Yes to No
Many thanks for your enquiry. The Understanding Society team is looking into it and we will get back to you as soon as we can.
Best wishes,
Stephanie Auty - Understanding Society User Support Officer
Updated by Stephanie Auty over 6 years ago
- Assignee changed from Stephanie Auty to Oliver Southwick
- % Done changed from 10 to 50
Dear Olly,
The values should add up correctly subject to a bit of rounding error (maximum value 1.25p), but it does depend a bit what exactly you have done.
In principle fimngrs_dv=fimnlabgrs_dv+fibenothr_dv+(fiyrinvinc/12) and this seems to work.
There is a slight glitch at wave 6 since there are numbers of cases of fiyrinvinc missing (-9). Setting these to zero, the above formula works.
If this does not resolve your issue it would be helpful if you could send some examples of the problem. Please email usersupport@understandingsociety.ac.uk directly if you are identifying individuals for data security reasons.
Best wishes,
Stephanie Auty - Understanding Society User Support Officer
Updated by Stephanie Auty over 6 years ago
- Status changed from In Progress to Feedback
- % Done changed from 50 to 80
Updated by Stephanie Auty over 6 years ago
- Status changed from Feedback to Resolved
- % Done changed from 80 to 100