3 Replies Latest reply: Sep 14, 2012 4:28 AM by j i RSS

    Display data according D and D-1

      I developed a dynamic array with two dimensions:
      Site and date
      plus two expressions:
      - The first one calculates KPI "PMC" on the selected date
      - And the other computes a KPI "PMC" whichever "selected day-1"

      calculates is correctly but the display is not as good.

      what i got
      Site           !       Date         !      Ending
      PMC  !       Begin PMC
      France       !       Total         !          239674      !         239839
      France       !   
      08/23/2012   !         239 674      !            0                 
      France       !   
      08/24/2012   !              0          !         239 839

       

       

      what I'm looking for

       

      Site           !       Date         !      Ending PMC  !       Begin PMC
      France       !       Total         !          239674      !         239839
       
      France       !   
      08/24/2012   !         239 674      !        239 839

       

       

       

      Why is the date D-1 is displayed?? it gives me 0, for the user is false data. I'm looking to display only KPI for the selected date ....!


      what should I do?


      Thank you.