My formula has a syntax error. if([PRECON] is TRUE, [SERVICES] - [PRE],0). PRECON is checkbox.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

SERVICES and PRE are numeric as is this formula field.  My intent is to calculate the difference of SERVICES and PRE is PRECON is checked.

Photo of mike

mike

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,894 Points 20k badge 2x thumb
Try this:

If([PRECON], [SERVICES] - [PRE], 0)
Photo of mike

mike

  • 0 Points
You da man.  Thanks!