Discussions

Expand all | Collapse all

Formula Summing field working based off a Checkbox field.

  • 1.  Formula Summing field working based off a Checkbox field.

    Top
    Contributor
    Posted 10-26-2018 16:29
    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.


  • 2.  RE: Formula Summing field working based off a Checkbox field.

    Bronze
    Contributor
    Posted 10-26-2018 17:22
    Retainage%? Sounds familiar? Jacobs/CH2M?


  • 3.  RE: Formula Summing field working based off a Checkbox field.

    Posted 10-30-2018 19:51
    Ashley
    Formula you are looking for
    If([Retainage With Held?]=true,Sum([Invoice Amount]*[Retainage %]),0)