Override Application Variables
Hi Everyone, Is there any way to override an application variable? The problem is that I will need to make an exception for an application variable. For instance, I would like to say if resource ty...
Forum Discussion
Are you trying to set your app variable?
Or rethink the equation
If ([Resource Type]="contractor", 1 , [Labor Multiplier])
Assuming labor multiplier is 2.7
------------------------------
Douglas Folk
------------------------------
Or rethink the equation
If ([Resource Type]="contractor", 1 , [Labor Multiplier])
Assuming labor multiplier is 2.7
------------------------------
Douglas Folk
------------------------------
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
Qrew 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
------------------------------ - MarkShnier__YouIf ([Resource Type]="contractor", 1 , ToText( [Labor Multiplier]))
Application Variables are type Text so need to be converted to Numeric
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------ Sorry –
The app variables are text so you'll have to covert the text to a number in the formula.
I will look deeper into it.
Sincerely,
Douglas Folk
Sr. Engineer
615.654.6101 phone 615.654.4449 fax
Specialty Water Technologies
104 Flex Avenue
Portland, TN 37148
THIS IS A CONFIDENTAL COMMUNICATION intended for the use of the recipient named above. If you are not the intended recipient of this communication, you are hereby notified that any dissemination, distribution or copying of this communication or attachments, is strictly prohibited. Please notify the sender by reply e-mail that you received this email in error or call 615-654-6101.
