Skip to main content
Question

My code using Sum function with the - operator.

  • September 24, 2018
  • 0 replies
  • 80 views
 What is wrong with my code?   [Apply Discount] is a checkbox  the rest are numeric formula fields.  [Discount] is a numeric field.  It will Sum but fails to subtract the [Discount] even when not used in the IF statement. 

If([Apply Discount]= true, Sum ([SoftScape Total],[HardScape Total],[Aggregate Total],[Removal Total]-[Discount]),Sum([SoftScape Total],[HardScape Total],[Aggregate Total],[Removal Total]))
    This topic has been closed for replies.

    Forum|alt.badge.img+17
    • EvanMartinez
    • Community Moderator
    • September 24, 2018
    Hi Billy,

    Have you tried wrapping just the section with the subtraction in its own set of parenthesis?

    If([Apply Discount]= true, Sum ([SoftScape Total],[HardScape Total],[Aggregate Total],([Removal Total]-[Discount])),Sum([SoftScape Total],[HardScape Total],[Aggregate Total],[Removal Total]))

    Just to make sure that Subtraction is being calculated first.
    • BillyBussey
    • Author
    • Registered
    • September 24, 2018
    Let me give it a shot. 

    • BillyBussey
    • Author
    • Registered
    • September 24, 2018
    It still doesn't do the subtraction.  I get the sum total whether Apply discount is checked or not. 
    Billy,
    Is the discount a dollar amount number or a %?
    Forum|alt.badge.img+17
    • EvanMartinez
    • Community Moderator
    • September 24, 2018
    Could you try putting in 1 instead of true for your checkbox really quick and see what you get back?

    So [Apply Discount]=1
    • BillyBussey
    • Author
    • Registered
    • September 24, 2018
    Good idea though, Here is the code that worked.    What you said made me think.  

    If([Apply Discount]= true, Sum ([SoftScape Total],[HardScape Total],[Aggregate Total],[Removal Total])-([Discount]),Sum([SoftScape Total],[HardScape Total],[Aggregate Total],[Removal Total]))
    • BillyBussey
    • Author
    • Registered
    • September 24, 2018
    It is a dollar amount. 
    • BillyBussey
    • Author
    • Registered
    • September 24, 2018
    The code I posted above worked.  Just the subtraction part needed to be in its own set of parentheses.  
    Terms & ConditionsAccessibility statement