Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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..
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.
You might be missing something. Can you attach your applicatino? (just the part that you need for this example)