Hi,
I need to create a formula which outputs the value for a single group. For example, two groups are:
Group: Year
Group: Products
I only need to place in the footer the total for year 2012, product jam. The report contains dteails for many products and years.
Any one help me with this formula?
Cheers,
Hi Leo,
Create this formula and place it on the Group Header 2. You may suppress this formula as we don't really need to display it.
WhilePrintingRecords;
numbervar summ;
if {Year} = 2012 and {Product} = "Jam" then
summ := Sum ({Product}, {Year}))
Note. If the {Year} field is a date field, then you need to use a function to extract the year like:
Year({Year_field}) = 2012
Create another formula to display the sum and Place it on the Report Footer:
WhilePrintingRecords;
numbervar summ;
Hope this helps!
-Abhilash
Hello Leo,
take a look at the option to create Running Total in Crystal Reports.
it also allows you to put in a logic which numbers should be totaled together.
regards
Ingo Hilgefort, SAP
Add a comment