Hi
I am trying to create a report with two groups - example: MainForm is the first group and the second group would be the forms for this group. I have a batchtotal for each group which I can get from summary. The second column requires a formula for date difference. Under Business Money Form 1 and 2 exceed KPI would be if datediff("d",recdate,enddate) >2 then 1 else 0 and I use this formula as a running total, then add it up but the next group of forms has a different KPI. My problem is the second grouping the Exceed KPI be if datediff("d",recdate,enddate)>3 then 1 else 0.
I am not sure how to accomplish -- for each group the forms within that group have a different KPI. The compliance is a percentage by form and MainForm.
Business Money Batch Total Exceed KPI Compliance
Form 1
Form 2
Business No Money
Form A
Form B
Any assistance is greatly appreciated - Thanks in advance
Kelley
I am trying to create a report with two groups - example: MainForm is the first group and the second group would be the forms for this group. I have a batchtotal for each group which I can get from summary. The second column requires a formula for date difference. Under Business Money Form 1 and 2 exceed KPI would be if datediff("d",recdate,enddate) >2 then 1 else 0 and I use this formula as a running total, then add it up but the next group of forms has a different KPI. My problem is the second grouping the Exceed KPI be if datediff("d",recdate,enddate)>3 then 1 else 0.
I am not sure how to accomplish -- for each group the forms within that group have a different KPI. The compliance is a percentage by form and MainForm.
Business Money Batch Total Exceed KPI Compliance
Form 1
Form 2
Business No Money
Form A
Form B
Any assistance is greatly appreciated - Thanks in advance
Kelley