You are viewing limited content. For full access, please sign in.



How to Sum multiple field values using Workflow

asked on December 6, 2018

I am retrieving multiple field values that all have a value of >=1 that we have setup in the search.  I am trying to sum all of these values, but continue to get the answer of 1.  When using the SUM action in the Token Calculator, it wants multiple values, but I only have the one token where it is retrieving the field values.  What am I missing?  Is there a way to split this out into multiple tokens from one Retrieve Field Values action?  Any help or guidance would be greatly appreciated.  Please see attachment for WF.

P.S. Only using the Find Entry and Assign Field Values to verify we are getting back the correct value.



Parcel WF.PNG
Parcel WF.PNG (12.8 KB)
0 0


replied on December 6, 2018

Alternatively skip the loop entirely. 

  1. Search Repository
    1. Retrieve Field Values as part of the search
  2. Assign Token Values
    1. Sum the results of the Search Repository token


3 0


replied on December 6, 2018

It looks like your token doesn't have multiple values because you're creating it fresh each time through the loop. 

Create the token before the loop, then modify the token to append values inside the loop.  That way your token calculator will have something to work with.

1 0
replied on December 21, 2018

Thank you very much for your input @████████.  With your help, we were able to get this working.



0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.