SubTotal of Line Items

[hondacur]

I'm am trying to find a subtotal from 2-tabbed portals. My SubTotal/Total/Tax/Discount/Shipping fields are in the Transactions table. TransactionDetails_Parts (related to Parts table)and TransactionDetails_Labor (related to Labor table)are related to Transactions by TransactionID. Each tab has a Part/Labor (respectively) portal for line items. Each line items totals properly in the ExtPrice Fields. I need to find the SubTotal for all ExtPrice Fields (parts/labor)to finish up the Transactions layout.

[bcooney]

You need a calc field in the transactions table = sum ( transactions_Labor::ExtPrice ) + ( transactions_Parts::ExtPrice)

[hondacur]

I guess I just don't understand how to write mathmatical formulas in the calculation field. Thank you, for the formula above...that works but, I can't seem to get the tax rate/discount/total fields to work properly.

I thought I should have a table MyBusiness that included the business info., including a TaxRate field (so if the tax changes, in business information then, the tax changes for all new records. I related the MyBusiness table to the Transactions table via the MyBusinessID field. So now I can type (auto enter) MyBusinessID - 1 in Transactions and the TaxRate field on the Transactions table changes to the correct tax rate. xSubTotal should be = (SubTotal*DiscountRate)+Shipping. Total should be = xSubTotal*TaxRate.

I don't think I am writing the math correctly when I enter it in the Specify Calculation. Currently, the only things working are the SubTotal field (thanks to you) and the Discount field.

[hondacur]

I figured out something that works...Thanks again.

.ramsey.