This discussion is archived
6 Replies Latest reply: Mar 5, 2013 3:16 AM by 976632 RSS

upto previous period data

976632 Newbie
Currently Being Moderated
Hi

how to get upto previous month data

if select aug-11 then i get upto jul-11 data for the aug-11

how to do this

i have gldate,startdate,enddate
  • 1. Re: upto previous period data
    Deep Explorer
    Currently Being Moderated
    Hi,

    Pass the value selected in the prompt to a report B and which has month and month -1 columns. Now in your currrent report use filter based on another request and filter the month column by month-1 column of report B.

    thanks,
    deep
  • 2. Re: upto previous period data
    976632 Newbie
    Currently Being Moderated
    Hi

    thanks for ur reply but
    but my requirement is different

    actually i have some date columns

    my condition is gldate<startdate

    my values are

    gldate values are like 1/31/2011,2/28/2011,3/31/2011,4/30/2011,5/31/2011 ...

    startdate values 1/1/2011,2/1/2011,3/1/2011,4/1/2011,5/1/2011 ..

    periodname --jan-11,feb-11,mar-11  likethsi

    if i select periodname nov-11 then

    startdate is 11/1/2011 and gldate is 11/30/2011

    my condition is gldate<startdate its false then all gives 0's

    my requirement is if i select periodname nov-11 then startdate is 11/1/2011 then iget the amount for the all gldate values <startdate

    startdate i compare all gldate values its not filtered

    then this condition get upto oct-11 values

    i nees for nov-11 values are upto oct-11 values sum

    plz how to dothis

    if ur not understand plz reply to me
  • 3. Re: upto previous period data
    Deep Explorer
    Currently Being Moderated
    Hi ,

    I find it difficult to understand. Let me put it this way

    Are you saying you have a period as prompt and when you select a period you need to display data for period -1. eg: you select nov-11 then you get data till oct-11?

    As I understand gldate is end of month date(1/31/2011,2/28/2011) and startdate is start month date(1/1/2011,2/1/2011,3/1/2011..)

    You want to display only values for gldate< startdate for selected period

    So for period nov-11 gldate = 11/30/2011 and startdate = 1/30/2011 so this implies that nov-11 shouldn't b displayed on rreport and shud only display from oct-11 which is same as displaying period-1.

    Is this correct?

    thanks,
    deep
  • 4. Re: upto previous period data
    976632 Newbie
    Currently Being Moderated
    Hi

    yes i need like this type

    ur correct

    but to get this

    can you give any other solution

    i get all null values


    lastperiod ending balance is current period beginning balance
    ie is the requirement
  • 5. Re: upto previous period data
    Deep Explorer
    Currently Being Moderated
    Hi,

    Sorry, cudn't respond. Is this still a issue?

    thanks,
    deep
  • 6. Re: upto previous period data
    976632 Newbie
    Currently Being Moderated
    Hi

    still its an issue

    i did nt get this

    can u know other solution for this

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points