Summarizing problem 1

[mikkom]

I need to calculate the age distribution of warehouse. I made a formula which shows stock value if there is no events for stock item in five years.

{@sum}
if ({@year} < ({?year}-4)
and (sum ({@stock_event}, {@year}) > 0))
then {stock.value}
else 0

But I also need total stock value of stock items more than five years old. And crystal don't summarize formula {@sum}. How I can't summarize it?

 

[lbass]

You can use a variable to sum your formula {@sum}:

Place the following formula in the same section where your {@sum} is located:

whileprintingrecords;
numbervar tot := tot + {@sum};

In the report footer, show the result using this formula:

whileprintingrecords;
numbervar tot;

if {@sum} is a currency, change "numbervar" to "currencyvar" in both formulas. If you are trying to sum at a group level, place the second formula in the group footer, and add a reset formula in the group header:

whileprintingrecords;
numbervar tot;
if not inrepeatedgroupheader then
tot := 0;

-LB

 

[mikkom]

Thanks, that solved problem!