Getting Started

 View Only
  • 1.  Override Application Variables

    Posted 01-07-2022 21:45
    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 type equals to "contractor", labor multiplier (Application variable) equals to 1, otherwise 2.7.
    I came up with the following formula which doesn't seem to work
    if([Resource Type]<> "Contractor", [labor multiplier]=1, 2.7)

    Thank you in advance

    ------------------------------
    Michael Naser
    ------------------------------


  • 2.  RE: Override Application Variables

    Posted 01-07-2022 22:18
    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
    ------------------------------



  • 3.  RE: Override Application Variables

    Posted 01-07-2022 22:38
    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
    ------------------------------



  • 4.  RE: Override Application Variables

    Posted 01-07-2022 23:08
    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
    ------------------------------



  • 5.  RE: Override Application Variables

    Posted 01-07-2022 23:10
    If ([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
    ------------------------------



  • 6.  RE: Override Application Variables

    Posted 01-08-2022 10:21

    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

    dfolk@specialtyh2o.com

    orders@specialtyh2o.com

     

    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.