Skip to Content

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 02, 2016 at 06:28 PM

    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

    Add comment
    10|10000 characters needed characters exceeded