Group subtotal and grand total

[former_member366557]

sir/madam,

Please help me on this

on how to get the subtotal and grandtotal of revenue, please see attached image for your reference thank you

code of formula revenue is like this \:

(Sum ({@5% Commission}, {OINV.NumAtCard})+Sum ({@AWB Fee}, {OINV.NumAtCard})) + (Sum ({@Freight}, {OINV.NumAtCard}) + Sum ({@FSC}, {OINV.NumAtCard})) + (Sum ({@Handling Fee}, {OINV.NumAtCard}) + Sum ({@Others}, {OINV.NumAtCard})) + (Sum ({@Processing}, {OINV.NumAtCard})) + (Sum ({@SSC}, {OINV.NumAtCard}) + Sum ({@Trucking Fee}, {OINV.NumAtCard}))

regards

silent

[abhilash_kumar · Accepted solution]

Hi Silent,

Create a formula with this code:

{@5% Commission} + {@AWB Fee} + {@Freight} + {@FSC} + {@Handling Fee} + {@Others} + {@Processing} + {@SSC} + {@Trucking Fee}

Go to the Insert Summary option > choose this formula field as the Field to Summarize > choose Sum as the summary operation > under summary location, choose All levels.

-Abhilash

[former_member366557 · Accepted solution]

HI ABHILASH

THANK YOU VERY MUCH, ITS WORK!!!

Sorry iam just a beginner of creating a script / Crystal report.

THANK YOU

Regards

Silent