Skip to Content
0

Acummulated value formula by Group

May 01, 2017 at 01:24 PM

34

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vitaly Izmaylov
May 01, 2017 at 10:13 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Refeesh Aliyar May 08, 2017 at 07:29 AM
0

@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};


Show 1 Share
10 |10000 characters needed characters left characters exceeded

Move the reset formual to either a higher group or the Report header

Ian

0