Forum Discussion

BillyBussey's avatar
BillyBussey
Qrew Trainee
7 years ago

My code using Sum function with the - operator.

 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...
Tables and fields
BillyBussey's avatar
BillyBussey
Qrew Trainee
7 years ago
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]))
  • EvanMartinez's avatar
    EvanMartinez
    Moderator
    7 years ago
    Nice I'm glad to hear that worked