Forum Discussion
MichaelNaser
Qrew Trainee
Hi Douglas,
I have already set the value for my app variable (labor multiplier=2.7). When try to use your formula it gives me following syntax error:
"excepting number but found text"
*My field type is Numeric-formula
------------------------------
Michael Naser
------------------------------
I have already set the value for my app variable (labor multiplier=2.7). When try to use your formula it gives me following syntax error:
"excepting number but found text"
*My field type is Numeric-formula
------------------------------
Michael Naser
------------------------------
MarkShnier__You
3 years agoQrew Legend
If ([Resource Type]="contractor", 1 , ToNumber([Labor Multiplier]))
Application Variables are type text so need to be converted to numeric.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Application Variables are type text so need to be converted to numeric.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Related Content
- 3 months ago
- 6 months ago