I have a report where I want to show a chart that displays the KPI target met yesterday, and the average KPI target met over the last 3 months
No problems with the 3 month average measure, but the formula to get yesterday's KPI works in the report footer, but not in the report header, where the chart is placed.
The formula I an using is
if {dsplit.row_date} = currentdate -1 then
100*(Sum({dsplit.acceptable},{dsplit.row_date}))/sum({dsplit.callsoffered},{dsplit.row_date})
else 0
is there any way round this?
Thanks
No problems with the 3 month average measure, but the formula to get yesterday's KPI works in the report footer, but not in the report header, where the chart is placed.
The formula I an using is
if {dsplit.row_date} = currentdate -1 then
100*(Sum({dsplit.acceptable},{dsplit.row_date}))/sum({dsplit.callsoffered},{dsplit.row_date})
else 0
is there any way round this?
Thanks