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.

accumalated-balance-per-item.png

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 01, 2017 at 10:13 PM

    I think you just need to add a Reset formula:

    Whileprintingrecords;

    numbervar Sump:=0;

    and place the formula to the Group Header.

    I would also suggest to add "Whileprintingrecords;" to the top of your Variance_RT formula

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 08, 2017 at 07:29 AM

    @Vitaly Izmaylov its working fine but only the problem for me now i need the group to be accumulated but in this case each line is calculating only kindly check the result.

    the red mark is our formula and green mark is the running total. i have to get the answer like that. below is my formula . please advice.

    numbervar Sump:=0;

    numbervar Sump;

    Sump := Sump+{@Variance};

    Add comment
    10|10000 characters needed characters exceeded