1

I am new to SugarCRM. I have a requirement to calculate a field value through studio. But, in one of the fields which comes in denominator can be 0. So, i want to modify the formula through ifElse, how to do that.

Example - If (field1>0){calcField/field1} else(calcField=0).

Atul kumar singh
  • 454
  • 10
  • 24

1 Answers1

1

you can use calculated field , if else like this: 

ifElse(equal($status,"Held"),1,0)

For more information check this link :

Calculated field in sugarcrm

Amitesh Kumar
  • 3,051
  • 1
  • 26
  • 42