Forum Discussion

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

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

Moderator

7 years ago

Nice I'm glad to hear that worked

Forum Discussion

My code using Sum function with the - operator.

Related Content

Using Grid Edit to Edit Multiple Records at Once

Do unused tables related to currently used tables cause functionality problems?

Using AND with Null values

Multi select Text Functions

Using variables with class='SaveBeforeNavigating