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

Question

Question

How to Sum multiple field values using Workflow

asked on December 6

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.

Thanks,

Bill

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

Replies

replied on December 6

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

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
You are not allowed to follow up in this post.

Sign in to reply to this post.