If check box is check minus field amount from total

  • 0
  • 1
  • Question
  • Updated 3 weeks ago
  • In Progress
  • (Edited)
Hi There,

I need some help with an if statement in my field.

Currently my [rate total] field is a sum of many fields added all up as below:

Sum([Cost - Total],[Markup],[Trucking Cost],[Stuffing Cost],[Cost - GRI])

I currently have a check box that I want a user to click if they need to subtract a specific amount in another field from the total

If [CT LSS collect] = true

I need the system to subtract the amount in field [CT LSS] from the total.


Photo of oliver mah

oliver mah

  • 920 Points 500 badge 2x thumb

Posted 3 weeks ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,520 Points 50k badge 2x thumb
Sum([Cost - Total],[Markup],[Trucking Cost],[Stuffing Cost],[Cost - GRI])
- IF([CT LSS collect]=true, [CT LSS],0)