I have a field Redeemed where the user will redeem the points. Now I have to allocate these redeemed points to the projects which he worked. For every project we need to allocate only 20 points. How can I divide and allocate the points to the projects? For example, if a user redeemed 85 points in the month of April. If he worked on following projects from Jan P1 and P2 and Feb P3 and P4 and Mar P5.
Projects worked by every user will vary.
Earned by the User 1: 85
| Redeemed |
| Jan | Feb | Mar | April |
P1 | | | | 20 |
P2 | | | | 20 |
P3 | | | | 20 |
P4 | | | | 20 |
P5 | | | | 5 |