Formula Summing field working based off a Checkbox field.

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
Need help creating a formula. I have a Formula Field that calculates (sums) the Invoice Amount (Numeric) with the Retainage Percentage (Percentage/ Relationship Field) and provides the Amount of Retainage that needs to be withheld on said invoice. I would like this field to only Sum though based on a Checkbox Field being Checked. If the Checkbox isn't checked then the field doesn't calculate.
Photo of Ashley Harris

Ashley Harris

  • 70 Points

Posted 10 months ago

  • 0
  • 1
Retainage%? Sounds familiar? Jacobs/CH2M?
Photo of Andrew Noy

Andrew Noy

  • 60 Points
Formula you are looking for
If([Retainage With Held?]=true,Sum([Invoice Amount]*[Retainage %]),0)