4 Replies Latest reply: Nov 18, 2011 4:28 AM by mioju lkjuo RSS

    Filter between two dates

    mioju lkjuo

      What's wrong?

       

      NTrabajoFechaFinReal2sum({<FechaFinReal2={">= 01/01/2011 <=31/12/2011" }>} Horas)
      473586,824
      DD-2001-A21/11/19971,25
      DP-0219-A12/06/19988
      DP-0416-A31/12/199810
      DP-0417-A01/10/19981
      DR-0096-A15/06/19982
      DR-0300-A06/11/19984,5
      ED-0011-A18/01/19994,5
      ED-0047-A30/03/19992
      ED-0146-A17/12/19992,5
      EP-0056-A29/03/19990,75
      EP-0280-A24/01/20110,45
      EP-0301-A22/02/200010

       

      Thanks

        • Re: Filter between two dates
          John Witherspoon

          What numbers do you WANT to see?  Why?

           

          What you MAY have expected was for the set analysis to override your dimension value.  It doesn't.  It INTERSECTS your dimension value.  If the dimension is in range, it'll use the dimension.  If not, you'll get null.  If you instead need to override your dimension value, you'd use the 'total' key word:

           

          sum({<FechaFinReal2={">=01/01/2011 <=31/12/2011" }>} total Horas)

           

          I have no idea if that's what you want, though.

            • Filter between two dates
              mioju lkjuo

              Thanks John,

               

              I try to explain me. I want present a table with all "NTrabajos" (jobs), which "FechaFinReal2" (finaldate) is in 2011, and present  the "Horas" (dedications; hours) worked and each job.

               

              For example:

              NTrabajoFechaFinReal2sum({<FechaFinReal2={">= 01/01/2011 <=31/12/2011" }>} Horas)
              0,45
              EP-0280-A24/01/20110,45
              • Re: Filter between two dates
                mioju lkjuo

                Thanks John,

                 

                I try to explain me. I want present a table with all "NTrabajos" (jobs), which "FechaFinReal2" (finaldate) is in 2011, and present  the "Horas" (dedications; hours) worked and each job.

                 

                For example:

                NTrabajoFechaFinReal2sum({<FechaFinReal2={">= 01/01/2011 <=31/12/2011" }>} Horas)
                0,45
                EP-0280-A24/01/20110,45
                  • Re: Filter between two dates
                    mioju lkjuo

                    I've found the error:

                    sum({<FechaFinReal2={">= 01/01/2011 <=31/12/2011" }>} Horas)

                                                            Î this space is the error.

                    The correct form is:

                    sum({<FechaFinReal2={">=01/01/2011 <=31/12/2011" }>} Horas)