Hi,
I am working in a holidays app and I need to get the current balance of days for each employee.
I have these collections, I need to get the result "colBalance":

The colBalance is the sumatoria of the days of the Year (A) plus (if the employee has) the pending days at the colPreviousYear (B) less the days requested in colHolidays (C)
A + B - C
Here the sample collections:
ClearCollect(colYear, {Country: "USA", Year: 2024, Days:20});
ClearCollect(colPreviousYear,{User: "Emilio", PendingDays:10},{User: "Paul", PendingDays:5});
ClearCollect(colHolidays,
{User:"Emilio", Country:"USA", Year:2024, DaysRequested: 10},
{User:"Emilio", Country:"USA", Year:2024, DaysRequested: 5},
{User:"Linda", Country:"USA", Year:2024, DaysRequested: 5},
{User:"Linda", Country:"USA", Year:2024, DaysRequested: 7},
{User:"Paul", Country:"USA", Year:2024, DaysRequested: 25},
{User:"Peter", Country:"USA", Year:2024, DaysRequested: 15})
Is it possible? Thanks for any help!!