We have a workflow that takes information from two Sharepoint Lists and matches them together based on PERNER (Employee ID). Then take that information and send an email to each Employee. The issue is that each PERNER can have several Bucket Total Entries This is why we need to calculate the total sum of the entries returned for each PERNER and store it as a new variable.
Here is an example
This is the Bucket Total for one PERNER the total for this PERNER should be 7,496 instead, the workflow adds the previous PERNER’s Bucket Total to this total. With that said, by the end of the workflow we essentially have a grand total of all PERNERs instead of individual total for each PERNER.
Here is how the workflow is arranged
