Need help with formulas

[Fermo Zolli]

Hi, everybody,

Tried to insert following formulas in one report of Crystal Reports:

@pippo placed in the detail section:
whileprintingrecords;
numbervar pippo;
pippo := sum ({LOCATION.SRLO_EFFECTIVE_VALUE});

@results placed in the group footer:
whileprintingrecords;
numbervar pippo;

@Reset placed in the group header:
whileprintingrecords;
numbervar pippo := 0;

The formula unfortunately is summing the full data base effective values and not resetting at every change of group code. Where am I wrong, please, cannot solve and became crazy? At the end I solved in a very simple way with the standard Summary function of Crystal, but I would anyway like to understand this better, for future applications.

Regards,
Fermo

 

[kray4660]

You should change your sum to look something like this. sum ({LOCATION.SRLO_EFFECTIVE_VALUE}, {Name of field you are grouping on})