I have a list in SharePoint 2013. Some of the items have the same Account#, and I'd like to be able to:
- Add the duplicating Account#'s together to get their total $Amount
- See how close that total is to a MaximumAmount ($AmountLeft and Percentage)
- Get email notifications based on how close to the MaximumAmount (50%, 80%)
Is there a possible way to do this?