Post reply

Aging Report

  • August 17, 2009 at 5:07 am

    #224903

    I have to create a report for aging and i am getting data as

    Qty Age

    -5 0-30Days

    7 31-60Days

    3 61-90 Days

    but i want data as

    Qty Age

    0 0-30Days

    5 31-60Days

    0 61-90 Days

    that means if i get negative value than that should be substracted from the oldest one and if oldest one becomes 0 then it should look out for the second last and so on.

    if anyone can provide the SQL query that will be really helpful

    Please help

    Thanks in advance

    Ravi

  • August 17, 2009 at 3:08 pm

    #1040525

    duplicate post.

    please continue discussion here .


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply