Skip to Content
author's profile photo Former Member
Former Member

Sum Of Fields in a group

Hi Experts,

i have a report contains a group by main brand and division.

I Have some sales fields in my report.i applied summary for all those fields based on Main brand group.I have a field called Number of weeks,For that i have to display no of weeks only,without summary.so i directly kept the Number of weeks field in group header where i kept all the summary values.i am getting the values for no of weeks as expected.Now i want to display sum of no of weeks in group footer of division.

Ex:

Sales no of weeks;

1 2

2 5

3 6

Sum 6 13 -> Group footer

As above now i want to display sum of no of weeks count as 13.

But i am not getting sum of weeks.can any one please resolve this.

I tried with below formula also but i am getting wrong values.

sum({Command.NO_OF_WKS},{Command.DEPT_CODE})

PFA

Reportgif.gif (196.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 28, 2013 at 08:18 PM
    12

    Hi Divya,

    --Create a running total based on based on {Command.NO_OF_WKS} field and choose the "for each Record" option in Evaluate category & "On change of group" option in reset category and select {Command.DEPT_CODE} group in "On change of group" option box...

    --Drag that Running total into Group footer.

    Hope this information will help you...

    --Naga.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Divya,

      Why have you removed the No_of_weeks column from the Group Header 8 section?

      What you now see is the Running Sum and that's what is is making you think that the sum is not correct.

      Do this

      1) Add the {Command.No_of_weeks} field back to the Group Header 8 Section

      2) If you have used the 1st method (using three formulae) I posted above, then add the 1st formula in the Group Header 8 section

      3) Add the display formula to the Group Footer 1 (which I can see that it's there because I also see 227 which is the correct sum)

      and 4) Add the reset formula to the Group Header 1

      -Abhilash

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.