Hi,
I want to allocate income amount to customers based as below
1) The first adult in the tenancy gets allocated income amount 585. The other adults in the tenancy get allocated 225.
2) Similarly the first child in the tenancy gets allocated income amount 285 and the 2nd, 3rd, etc childern get allocated 95
I have uploaded my sample dataset and desired output here:
https://app.box.com/s/lhexkurnfhitwirl9aut7ff9y4537vy8
Thanks
Jag
Solved! Go to Solution.
I took a simple approach to this. I created an Allowance table to append to each row. This externalizes the amounts from the program. You could store this outside of the module and call it with updated values in the future. I separate the Adults from the Children and then assign a person number (by Adult vs Child) to each HH member. After I append the values, it is a simple IF THEN statement that assigns the amounts.
I hope that this solves your need.
Thanks,
Mark
Thanks Mark but in the final output under the income column i get True instead of the allocation amount.
Thanks
Jag