Skip to Content
avatar image
Former Member

Acummulated value formula by Group

i am making a report to do the accumulated value per item similar to running total. i cannot use the running total for such situation which is having more formula is associated this filed. so i need to make a formula to separate by group.please find the picture which i made the formula.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 24, 2017 at 12:54 PM

    kindly help me

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 19, 2017 at 03:07 PM

    You need to give more info

    Generally for variables you need two formula. The one you have highlighted is the evaluation type. This should be placed in details or on group footer when Sump will be incremented and suppressed. Also I add command

    whileprintingrecords;

    to top of all variable formula,

    To display result create another formula and place this in report footer, if in a higher group you will also need a reset

    @display

    Whileprintingrecords;

    numbervar sump;

    If required add this to higher group header and suppress

    @Reset

    Whileprintingrecords;

    numbervar sump:=0;

    Ian

    Add comment
    10|10000 characters needed characters exceeded