1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Average Overdue Days in Outstanding Reports.

Discussion in 'Tally Developer' started by zakirhossain_diu, Jun 29, 2019.

    
Tags:
  1. zakirhossain_diu

    zakirhossain_diu Member


    Dear Experts,
    What formula can help to get Average Overdue Days in Report. Like Customer A had 4 Overdue Bills as 4 days, 5 days, 3 days, 8 days.
    Output should be 5 days. as (4+5+3+8=20/Num of Overdue Bill 4)

    Thank You
     

    Attached Files:

    zakirhossain_diu, Jun 29, 2019
    #1


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use $$NumItems to get the "4"

    Use Aggr Compute in Collection to add the overdue days

    then apply the formula.
     
    Amit Kamdar, Jul 2, 2019
    #2
    zakirhossain_diu likes this.


  3. sivam

    sivam Active Member


    Calculate Due Days & Dummy Counter in Main Collection

    Use Aggr Compute to Calculate Total Days and Total Counter

    Now u can Avg it as per your Requirement
     
    sivam, Jul 5, 2019
    #3
    zakirhossain_diu likes this.


Share This Page