Question

Create token using division formula in workflow

Workflow

Updated April 26, 2016

asked on April 26, 2016

I am trying to create a token using values from a lookup. The formula I entered in the Assign Token dialog box

=%(QueryAccountCode_TOTAL BILLING)/%(QueryAccountCode_NO/# OF PAYMENTS SEPT-AUG)

Which returns -

=21263.0000%(QueryAccountCode_NO/# OF PAYMENTS SEPT-AUG)

This syntax

%(QueryAccountCode_TOTAL BILLING)\%(QueryAccountCode_NO/# OF PAYMENTS SEPT-AUG)

Returns

21263.0000\1

This syntax

=sum(%(QueryAccountCode_TOTAL BILLING)\%(QueryAccountCode_NO/# OF PAYMENTS SEPT-AUG))

Returns

=sum(21263.0000\1)

Can I make it give me the calculated value?

What I need is it to be 21263.00

0 0

Answer

SELECTED ANSWER

replied on April 26, 2016

I don't believe you want the Assign Token activity. You would want to use the Token Calculator activity and use the Quotient rule

QUOTIENT(variable 1, variable 2 )

0 0

Replies

replied on April 26, 2016

The / in front of the % is an escape character, so it turns it into the literal string, rather than resolving it. But Chris is right, Assign Token Values does not do math on its own. You need Token Calculator.

0 0

replied on April 26, 2016

Thank you, I knew it was a simple answer. Sometimes it is just too obvious...

0 0

You are not allowed to follow up in this post.

Question

Question

Create token using division formula in workflow

Answer

Replies

Sign in to reply to this post.