Question

Trying to sum field values in workflow

Workflow How To

Updated June 26, 2019

asked on June 26, 2019

I'm using Search Repository to retrieve field values and then trying to use Token Values to sum all of the values retrieved. I continue to get an answer of 1 and I'm guessing it's bc it stats that "Token does not support multiple values". I'm sure this is possible to do, just not sure what I'm missing, or if there is a better way to accomplish this. Any help or guidance would be greatly appreciated.

Thanks!

0 0

Answer

SELECTED ANSWER

replied on June 26, 2019

Oh, I see. You're using the token generated by Search repository, so you're only seeing the page count for the first hit.

You'll need to use a For Each Entry to collect the values from all the results before you sum them up.

0 0

Replies

replied on June 26, 2019

Can you show where you define this token?

0 0

replied on June 26, 2019

Thanks for your quick response Miruna. Is this what you mean by define?

0 0

View 1 previous reply

replied on June 26, 2019

I apologize, but I don't understand what you are asking for. Could you please provide me with an example of what you are referring to? I really appreciate your help with this.

0 0

SELECTED ANSWER

replied on June 26, 2019

Oh, I see. You're using the token generated by Search repository, so you're only seeing the page count for the first hit.

You'll need to use a For Each Entry to collect the values from all the results before you sum them up.

0 0

replied on June 26, 2019

Fantastic.......thank you for your very in depth description. Very complex, but seems to give us what we need.

Thanks again!!

0 0

You are not allowed to follow up in this post.

Question

Question

Trying to sum field values in workflow

Answer

Replies

Sign in to reply to this post.