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

    Calculation

    bennyhendrikx

      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 )

       

       

      but its all wrong please help me out

       

       

        • 1. Re: Calculation
          Abhaya

          Hi

          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

           

          Thanks

          • 2. Re: Calculation
            LaRetta_1

            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
              bennyhendrikx

              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