3 Replies Latest reply on Aug 29, 2011 6:53 AM by bennyhendrikx

# Calculation

### Title

Calculation

### Post

Hello all ,

Wondering if it is possible becorse i cant figured it out ,

in the line items i have check field for tax ,

if field is checked the formule for the grand total should be  ,  sub total + tax +shipping

when it not checked the formula is  sub total +  shipping

i just want to use one grand total  what function do i need was trying with if something like this

Case ( Line Items::Taxable ;"1"  =  Subtotal + tax + Shipping ) or Case (  Line Items::Taxable  ;"0"  = Subtotal + Shipping )

• ###### 1. Re: Calculation

Hi

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

Thanks

• ###### 2. Re: Calculation

Hi Benny,

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?

• ###### 3. Re: Calculation

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