Sorting Problem in report

Discussion in 'Tally Developer' started by Johar, Feb 14, 2019.

    
  1. Johar

    Johar Member


    Attached screen shot of report in that sorting problem is there as first it comes zero then the higher value, iam using following collection for the report please suggest what is wrong.

    [Collection: TopitemSalesCollS]
    Source Collection : TopPIMD VoucherS
    Walk : Inventory Entries
    By : topitemname : $StockItemName
    Aggr Compute : itemQtyAprS : Sum : If @@vchtypeSalY and @@TopmonthFilteraprS Then $BilledQty Else 0
    Aggr Compute : itemTotalQtyS : Sum : If @@vchtypeSalY then $BilledQty else 0
    Compute : topitemcat : $Parent:StockItem:$StockItemName
    Filter : VchFltCatsales
    Sort : Default : $itemTotalQtys


    Thanks
    Johar
     

    Attached Files:



  2. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Sort : Default : $itemTotalQtys

    Sort : @@Increasing : $itemtotalQtys or
    Sort : @@Default : -$itemTotalQtys
     


  3. Johar

    Johar Member


    Thanks Pankaj, but its not working
     


  4. Jenny

    Jenny Active Member


    Sort : @@AmtIncr : $itemTotalQtys
     


  5. Johar

    Johar Member


    nope not working
     


  6. Jenny

    Jenny Active Member


    post your full code
     


  7. Johar

    Johar Member


    Problem Solved by :

    Sort : @@Default : -$$Number:$itemTotalQtyS

    Thanks for the help
     


Share This Page