Thread Details
  • State Not Answered
  • Replies 1 reply
  • Subscribers 354 subscribers
  • Views 587 views
  • Users 0 members are here
Forum Actions
Related

Sugar Formular issue

Oluwafeyijimi Joshua Arimoro

Hi Everyone. 

I am trying to create a calculated field and it is giving me an issue can you guys see any issue. I have the formular in english and the one in code under. I keep getting a parentheses issue

Formular

Unit Cost (CAD) x ( 1 / ( standardwidth / 100 ) )

Code:

ifElse(equal($unitofmeasure_c,"SQM"),multiply($unit_cost_cad_c,divide(1,divide(standardwidth_c,100))),0)

Formular:

Unit Cost (CAD) x ( ( ( 1 / ( standardwidth / 100 ) ) / 1.19599 ) )

Code:

ifElse(equal($unitofmeasure_c,"SQY"),multiply($unit_cost_cad_c,divide(1,divide(standardwidth_c,100)divide(1.19599))),0),

Formular:

Unit Cost (CAD) x ( ( ( 1 / ( standardwidth / 100 ) ) / 10.76391042 ) )

Code:

ifElse(equal($unitofmeasure_c,"SQF"),multiply($unit_cost_cad_c,divide(1,divide(standardwidth_c,100)divide(10.76391042))),0) 

  • 0

    In your code which is hard to read in red. 

    You have 

    ifElse(equal($unitofmeasure_c,"SQF"),multiply($unit_cost_cad_c,divide(1,divide(standardwidth_c,100)divide(10.76391042))),0)

    At a minimum you are missing a, (comma) after the ,100) and before divide

    standardwidth_c is missing a $

    ifElse(equal($unitofmeasure_c,"SQF"),multiply($unit_cost_cad_c,divide(1,divide($standardwidth_c,100),divide(10.76391042))),0)