Discussions

 View Only
  • 1.  If check box is check minus field amount from total

    Posted 02-28-2019 18:44
    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.




  • 2.  RE: If check box is check minus field amount from total

    Posted 02-28-2019 18:51
    Sum([Cost - Total],[Markup],[Trucking Cost],[Stuffing Cost],[Cost - GRI])
    - IF([CT LSS collect]=true, [CT LSS],0)