Good afternoon,
I am in the process of creating a SharePoint 2010 list form in InfoPath 2010. The aim of the list form is to monitoring funding. Users will complete the list form and put an amount of funding that they would like. I need to create a field which will hold the total amount of money that we have available to give out. What I need to have that do, is everytime someone completes a form and adds an amount is reduce the total fund column.
For example:
Total Fund Column = £100
users complete 3 separate entries which need funding of £25 for each entry, which would total £75
The Total fund column would then show a fund of £25
I hope this makes sense and that someone can help.
Many thanks