6 Replies Latest reply: Mar 5, 2013 5:16 AM by 976632 RSS

    upto previous period data

    976632
      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
          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
            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
              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
                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
                  Hi,

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

                  thanks,
                  deep
                  • 6. Re: upto previous period data
                    976632
                    Hi

                    still its an issue

                    i did nt get this

                    can u know other solution for this