Grand total of sub totals

Discussion in 'Tally Developer' started by Rupal Agarwal, May 28, 2022.

    
  1. Rupal Agarwal

    Rupal Agarwal Member


    Hello everyone,

    I have created a report for inventory details. now i want to get the grand total of sub totals of items accourding to their group.


    My code is given :

    Code:
    [Line:ISR]
        Field:ISR Name, ISR Qty, ISR rate, ISR Value, ISR Disc, ISR Amt, ISR Tax, ISR TaxAmt, ISR Total
       
    [Field:ISR Name]
        Use:Name field
        Set as: $name
        Width: 30% screen
        Align:Center
        Space Left:10% screen
       
    [Field:ISR Qty]
        Use:Qty field
        Set as: $billQty
        Width: 10% screen
        Align:Right
        Style:normal
        Format:"No zero"
       
    [Field:ISR Rate]
        Use:Number field
        Set as: $nrate
        Width: 10% screen
        Align:right
        Format:"No zero"
        Style:normal
       
    [Field:ISR Value]
        Use:Number field
        Set as: $billedqty * $rate ;$value
        Width: 10% screen
        Align:right
        Format:"No zero"
        Style:normal
       
    [Field:ISR Disc]
        Use:Number field
        Set as: $disc
        Width: 10% screen
        Align:right
        Style:normal
        Format:"No zero"
       
    [Field:ISR Amt]
        Use:Number field
        Set as: $amount
        Width: 10% screen
        Align:right
        Style:normal
        Format:decimal:0
       
    [Field:ISR Tax]
        Use:number field
        Set as: $tax;$gstrate
        Width: 10% screen
        Align:right
        Style:normal
        Format:"No zero, percentage"
        Set Always:Yes
    
    [Field:ISR TaxAmt]
        Use:Number field
        Set as: #ISRTotal - #Isramt
        Width: 10% screen
        Align:right
        Style:normal
        Format:"no zero, decimals:0"
       
    [Field:ISR Total]
        Use:number field
        Set as: #ISRAmt + (#isrtax/100 * #ISRamt)
        Width: 10% screen
        Align:Right
        Format: "no zero, decimals:0, Symbol," + ##ShowForex
        Style:normal
    
    
    [Collection:Isr Base coll]
        Type:Vouchers
        Fetch:Stockitemname, Billedqty, Rate, Discount, Amount, GSTIGSTRate
        Belongs To:Yes
    
    [Collection:ISR Coll]
        Source Collection:ISR Base Coll
        Walk:inventory entries
        By:name:$Stockitemname
        By:nrate:$rate
        By:tax:$GSTIGSTRate:StockItem:$StockItemName
       
        Aggr Compute:amount:Sum:$Amount
        Aggr Compute:BillQty:Sum:$billedQty
        Compute:Disc:$discount
       
        Fetch:billedqty, rate, discount, amount, Stockitemname,GSTIGSTRate
        Fetch:*
       
        Filter:IsrGrpName
        Sort: @@default :$name
       
    [System:Formulae]
        ISRGRPName: $parent:stockitem:$stockitemname = #IsRGrpName and  $$IsEmpty:$closingbalance
    and i want :
    Screenshot 2022-05-28 142642.png
     


  2. balajimg

    balajimg Active Member


    use new field definition in Category total and intern use $$Total:Newfield in grand total line
     


  3. kosi

    kosi Member


    Add storage at sub total fields and do this at grand total field
    Storage1 + storage2 + storage3
     


  4. Rupal Agarwal

    Rupal Agarwal Member


    tried this but not working
     


  5. Rupal Agarwal

    Rupal Agarwal Member


    will the storage value will be changed according to the line /selected period
     


  6. kosi

    kosi Member


    Explain well
    Can't help u if u don't explain well
    U can past full code for us to go through and help u
     


  7. Rupal Agarwal

    Rupal Agarwal Member


    Check attachments.

    I want the grand total from category total
     

    Attached Files:



  8. kosi

    kosi Member


    category total
    grand total is calcutated according to category total in your screen short.
    maybe im not understanding your problem
     

    Attached Files:



  9. kosi

    kosi Member


    category total
    grand total is calcutated according to category total in your screen short.
    maybe im not understanding your problem
     


Share This Page