1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

help me to filter highest amount in a collection

Discussion in 'Tally Developer' started by mutharasan, Jul 23, 2015.

    
  1. mutharasan

    mutharasan Member


    Dear All Tdl Experts,

    Is it possible to filter highest Amount value in a collection? I want to filter highest Amount in the following collection. Please If is it possible guide me.

    [collection : tsalescoll]
    Type : Vouchers:Vouchertype
    child of : $$vchtypeSales
    Belongs To : yes
    Fetch :voucherNumber ,partyledgerName, Amount,LedgerEntries

    [collection : Turnovercoll]
    Source collection : tsalescoll
    Walk :LedgerEntries
    By:MyptyLedger:$PartyledgerName
    Aggr Compute:MyptyLedger:$PartyledgerName
    Aggr Compute:Myptyamt:Sum:$Amount

    Thanks in Advance, Please Help me...
     
    mutharasan, Jul 23, 2015
    #1


  2. admin

    admin Administrator Staff Member


    there are couple of ways to do.

    1. Sort the collection in Incremental mode based on Amount
    2. Write $$CollectionField:$Myptyamt:1:Turnovercoll


    OR

    In the colelction itself,

    Use MAX - Keyword for Aggr Compute
     
    admin, Jul 24, 2015
    #2
    mutharasan and HVPatel like this.


  3. mutharasan

    mutharasan Member


    Super Sir, Thank you very much.
     
    mutharasan, Jul 28, 2015
    #3


Share This Page