[#LINE:VCHNARRATION] Add:Field:After:VCHNARRATION:TOTALTOPS [Field:TOTALTOPS] Use : Qty Primary Field Set By Condition: @@TOTALTOP Set always : Yes Skip : Yes Style : Normal Border:TOTALS [System:Formula] TOTALTOP :$$FilterQtyTotal:TOTALTOP:TOPPARENT:$SGQTy TOPPARENT :$SGNAME= "TOP" [Collection:TOTALTOP] Source Collection:.. Walk:All Inventory ENtries By:SGName : $Parent:StockItem:$StockItemName Aggr Method:SGQTy : Sum: $BilledQty
first compute SGNAME this value in collection. when use aggregate method convert in Qty in Number. if primery collection not work then use secoudry collection source of primery collection then fetch intial value from Primery collection then try and
Try this .... Code: [#LINE:VCHNARRATION] Add:Field:After:VCHNARRATION: TOTALTOPS [Field:TOTALTOPS] Use : Qty Primary Field Set as : @@GrpQty Set always : Yes Skip : Yes Style : Normal Border:TOTALS [System:Formula] GrpFilter : $Parent:StockItem:$StockItemName containing "Top" GrpQty : $$FilterQtyTotal:InventoryEntries:GrpFilter:$BilledQty
Try this Parent Group & Till Group Explode [#LINE:VCHNARRATION] Add:Field:After:VCHNARRATION:TOTALTOPSTillAllExp,TOTALTOPS [Field:TOTALTOPSTillAllExp] Use : Qty Primary Field Set as: @@TOTALTOPExplevel Set always : Yes Skip : Yes Style : Normal Border:TOTALS Background: Red [Field:TOTALTOPS] Use : Qty Primary Field Set as : @@TOTALTOPParent Set always : Yes Skip : Yes Style : Normal Border:TOTALS Background: Green [System:Formula] TOTALTOPExplevel : $$FilterQtyTotal:InventoryEntries:TOPPARENTExplevel:$BilledQty TOTALTOPParent : $$FilterQtyTotal:InventoryEntries:TOPPARENT:$BilledQty SGName : $Parent:StockItem:$StockItemName TOPPARENTExplevel : $$IsObjectBelongsTo:StockGroup@SGName:"Top" ;;; Till all explode level of 'Top' Group TOPPARENT : $Parent:StockItem:$StockItemName = "Top" ;;; Parent Group Total