Solved

Math Operation Calculating Previous Values

  • 2 August 2023
  • 2 replies
  • 58 views
E
Badge +4

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

Part of workflow Where this occurs 

 

Query List Action 
For Each Loop
Math Operation 

 

icon

Best answer by BobR 2 August 2023, 16:27

View original

2 replies

B
Userlevel 1
Badge +6

Sounds like you don’t reset the value between each loop. What you can do is after sending the email add a “Set Variable” action within the outer For Each loop that sets the “var_TotalPoints” back to 0 so the variable doesn’t retain the value it accumulated in a prior loop.

E
Badge +4

Sounds like you don’t reset the value between each loop. What you can do is after sending the email add a “Set Variable” action within the outer For Each loop that sets the “var_TotalPoints” back to 0 so the variable doesn’t retain the value it accumulated in a prior loop.

Thanks Bob! Solved it perfectly!

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings