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 :
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
category total grand total is calcutated according to category total in your screen short. maybe im not understanding your problem
category total grand total is calcutated according to category total in your screen short. maybe im not understanding your problem