Formula Syntax Error
Hello: I am having difficulty with a formula syntax. I am pretty green, and sadly my skillset has some "developmental opportunities." I am trying to do some calculations for equipment rental ba...
Forum Discussion
I can appreciate that.... I am just in a crunch to get things operational. I'm just a regular working guy (construction guy), so I am swimming a bit above my depth.
I do have a contract based rate system. So labor rates are entered under a contract number. So this should not impact rates on previous rate plans.
Its nice to know about snap shot fields, I will try to incorporate into my working knowledge.
Thank you so much
Dirk
I do have a contract based rate system. So labor rates are entered under a contract number. So this should not impact rates on previous rate plans.
Its nice to know about snap shot fields, I will try to incorporate into my working knowledge.
Thank you so much
Dirk
I must be doing something wrong:
Formula syntax error
Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.
var number Rate =
If(
[Associate - Labor Category]= "Carpenter" and [Staff Status]= "Dedicated" and [Hour Category]= "Standard",[Labor Rate - Dedicated Standard Rate],
[Associate - Labor Category]= "Carpenter" and [Staff Status]= "Dedicated" and [Hour Category]= "Premium",[Labor Rate - Dedicated Premium Rate],
[Associate - Labor Category]= "Carpenter" and [Staff Status]= "Variable" and [Hour Category]= "Standard",[Labor Rate - Variable Standard Rate],
[Associate - Labor Category]= "Carpenter" and [Staff Status]= "Variable" and [Hour Category]= "Premium",[Labor Rate - Variable Standard Rate],
// now we refer to the rate and multiply by the hours
$Rate * [Hours]
Formula syntax error
Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.
var number Rate =
If(
[Associate - Labor Category]= "Carpenter" and [Staff Status]= "Dedicated" and [Hour Category]= "Standard",[Labor Rate - Dedicated Standard Rate],
[Associate - Labor Category]= "Carpenter" and [Staff Status]= "Dedicated" and [Hour Category]= "Premium",[Labor Rate - Dedicated Premium Rate],
[Associate - Labor Category]= "Carpenter" and [Staff Status]= "Variable" and [Hour Category]= "Standard",[Labor Rate - Variable Standard Rate],
[Associate - Labor Category]= "Carpenter" and [Staff Status]= "Variable" and [Hour Category]= "Premium",[Labor Rate - Variable Standard Rate],
// now we refer to the rate and multiply by the hours
$Rate * [Hours]