I am trying to write a system to calculate annual leave days remaining. I have a list with each holiday being an entry. I want to add together the amount of days used previously. I have a textbox in which I want to store the number. I have got it to work so far by using the formula sum(WorkDays0) where 'WorkDays' is the column in the list which stores the number of days used for each holiday.
This works fine, except that I need it to only add the number of days when the holiday was created by the logged in user. I would need some kind of IF statement for this, and possible some kind of loop to loop through the holidays only adding the ones I want?
I haven't done any Infopath forms before, so I apologise if this is something that can't be done, or if it's something really easy.