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
EvanMartinez's avatar
EvanMartinez
Moderator
7 years ago
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.