Sum total in crystal report

Question

There is 3 doctypes A , B and C and there is amount of these values

What I have tried:

i.e.

Type_Number amount                        Sum= 2200       
A_12939848   2100
A_28387348   100
c_10000233   300

now i want sum of these values depend on Doctype

like this

Type_Number amount                        Sum= 2500       
A_12939848   2100
A_28387348   100
c_10000233   300

i use formulas for this

i select running total and select amount field and also fix A and C type like this employees.type in ['A','C'] then i save with amount_formula name then i drag this field on report

after this i create shared formulas and then i write this

shared tax as number
shared tax2 as number


tax=({#amount_formula})
tax2=tax2+tax
formula=tax
tax=0
i drag this on report

and second formula


shared tax2 as number
formula = tax2
tax2=0

but the sum display 2200 and i want 2500

any solution?

if you are grouping ['A', 'B'] I can imaging 'C' is not added to the sum — dmaij

Siva Siva · Accepted Answer · 2016-03-09T11:54:34

Don't create running total for every simple calculations instead try following way.

create a formula @Extract and write below code:

Type_Number[1];

Now create a group using this formula @Extract and place the fields in details.

For overall summary take report footer summary and for individual sum take group footer summary

Sum total in crystal report

1 Answers