Skip to Content
0

Acummulated value formula by Group

Apr 16, 2017 at 06:51 AM

53

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.

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

2 Answers

Refeesh Aliyar Apr 24, 2017 at 12:54 PM
0

kindly help me

Share
10 |10000 characters needed characters left characters exceeded
Ian Waterman Jul 19, 2017 at 03:07 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded