I'm using a calculation field to add a couple fields and then subtract a couple fields...very basic math functions, but as soon as I subtract more than one field, the calculation doesn't work despite how the screen states that its a valid formula. Here is what i'm trying to do:

You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

## Question

## zalipresents

I'm using a calculation field to add a couple fields and then subtract a couple fields...very basic math functions, but as soon as I subtract more than one field, the calculation doesn't work despite how the screen states that its a valid formula. Here is what i'm trying to do:

Field_A + Field_B - Field_C - Field_D - Field_E

I tried this and it didn't work:

[@field:Settle_Artist_Gross]+[@field:Settle_MERCH_Adjusted_Gross]-([@field:Settle_MERCH_Sales_Tax_Paid]+[@field:Settle_MERCH_House_Cut]+[@field:Settle_Total_Payouts])

thanks so much for your help!

## Link to comment

## Share on other sites

## 3 answers to this question

## Recommended Posts

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Note:Your post will require moderator approval before it will be visible.