Skip to Content
avatar image
Former Member

Running Total - Evaluating on Both 'Change of Group' and Formula

Hi,

I am trying to create a running total that needs to evaluate on "Change of Group 3" and also filter results using a formula. My formula is {@GroupingName = 'Location'}, where I have multiple running total fields to calculate each location. How can I accomplish this? Can I write a formula that will allow me to evaluate on the change of group and also filter results by name. Thanks.

Edited by: AMD_GAMER on Apr 21, 2010 8:12 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Apr 21, 2010 at 06:14 PM

    use manual running totals- wizard is buggy sometimes

    create 3 formulas

    reset --- goes in group header

    whileprintingrecords;

    numbervar x := 0;

    calc goes next to what is being calcualted

    whileprintingrecords;

    numbervar x := x + {field or formula};

    display goes where you would like the value to show

    whileprintingrecords;

    numbervar x;

    x

    Add comment
    10|10000 characters needed characters exceeded