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

Question

Question

Workflow Token Calculator Formula - Multiplication using decimal number

asked on February 23, 2017

I need to calculate a token in Workflow where a whole number (usually over 100) represented by a token will be multiplied by another number which will be either 1 or less than one (a decimal number) also represented by a token.  I have no problem with the formula when the multiplier is 1; however, when it drops below 1 (becomes a decimal), I get an invalid expression error.  My current test formulas are (100) * (1) which works, and (100) * (.5) which returns the error. Is there a formula type I should be using other than Multiplication?  

My case scenario is that I have a daily rate that I want to pay a crew boss, but if that crew boss worked in more than one location, I need to multiply the daily rate by the decimal that represents the percentage of the day they worked in this location in order to pay them only a portion of the amount on this particular location's paperwork.  

Any help you can give would be appreciated! 

0 0

Answer

SELECTED ANSWER
replied on February 23, 2017

Are you using the test formula in the token calculator?   Try using 0.5 instead of .5

1 0
replied on February 23, 2017

Thank you so much!!  That was the problem. 

0 0

Replies

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

Sign in to reply to this post.