Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Group subtotal and grand total

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

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question