Display data according D and D-1

[Anonymous]

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.

[MayilVahanan]

HI

     Try like this,

     =if(calculatesKPI"PMC"on the selected date > 0 ,

calculates KPI "PMC" on the selected date)

and for second expression  also..

Hope it helps..

[Anonymous]

do you know a function like LAG in SQL ?????

in my exemple, idont want to see the line with date = 08/23/2012 , beacause i did a selction on 08/24/2012.

Thx.

[jvitantonio]

You might be missing something. Can you attach your applicatino? (just the part that you need for this example)