Please proceed as follows..
Case(Lineitems::taxable=1;sub total + tax +shipping;
lineitems=0;sub total +shipping)
This calculation must put in the grandtotal field(which is a unstore calculation field) .when it check/uncheck the tax
e.g if 1 then sub total + tax +shipping
otherewise sub total +shipping
It is not clear where the Shipping and Tax come from and whether you are taxing individual LineItems or the complete Invoice (you mention grand total).
If you put the checkbox for 'tax' in the LineItems table, then your parent table (Invoices?) won't see that checkbox if the LineItem isn't the FIRST related record.
Please clarify the relationship between the two tables and whether LineItems individually are taxed and if so, where the tax values come from, or whether the parent (invoice) is tax if ANY of its LineItems is checked 'tax.' Where are Subtotal and Shipping and how are their totals derived? And what is the parent table?
THX ATAUF AND LARETTE
Thx for the fast reply`s ,
I did the folowing thing created a table ORDERS /FIELD ^CHECK BOX^ TAX . TABLE ORDER :FIELD SUB TOTAL TABLE ORDER :FIELD TAX AMOUNT
TABLE ORDER :FIELD TOTAL SUBTOTAL / FORMULA
Sum ( Line Items::Extended Price )
TABLE ORDER :FIELD TOTAL PLACED THE FORMULA
Case(Tax_Check= 1;Subtotal + tax +Shipping;
Tax_Check= 0;Subtotal +Shipping
WORKING GREAT THANKS ATAUF
FOR LINE ITEMS I DID THE FORMULA
PLACED A FIELD TAX AMOUNT WITH FORMULA
Extended Price * Orders::Sales Tax
HOPE I DID IT OKAY ITS WORKING ....
THX FOR THE HELP
LARETTE AND ATAUF