Skip to Content
0
Former Member
Oct 28, 2008 at 03:12 PM

Different target values for different group summaries

21 Views

Hope you can assist. I have a report written which groups by date (monthly) and summarises different information in the group footer, with a grand total.

One of the grand total summaries shows a grand target figure. To show this figure I have written a formula to utilise the groupnumber so if two months are showing then the grand target figure (with a monthly target of £2560) shows as £5120 i.e. {@GrandGroupNo}*2560. This enables me to show how much they are off or on target figures.

However, I am now being asked to show a different target i.e. September and October is remaining at £2560, November needs to be £3360 and December onwards needs to be £3600.

How do I variate the target figure each group footer and then get a grand target value as the grand total field so that I can show the above/below target figure overall?

Hope the above makes sense.