Forum Discussion

MichaelNaser's avatar
MichaelNaser
Qrew Trainee
3 years ago

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 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
------------------------------
Formulas and functions
  • DouglasFolk's avatar
    DouglasFolk
    Qrew Cadet
    3 years ago
    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
    ------------------------------
    • MichaelNaser's avatar
      MichaelNaser
      Qrew Trainee
      3 years ago
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        3 years ago
        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
        ------------------------------