Sum of a Group value

[Former Member]

CR 2011 Developer

Hi,

I know I've done this before, but the juggle eludes me at the moment...

I have a report with Group1- Product

                         and Group2-Size

Detail line displays the Min and Max order stock values, all the same for a given size.

At the Group2-Size-Footer level, I just display these values directly from the database.

Now I need to Sum the values from the Group2-Size-Footer at the Group1-Product-Footer level.

I know I've used a formula in the past, because I can't Sum the Detail, I have to Sum the value from Group2-Size-Footer

Do I need to set Min Max to formulas and sum that?  Do I need to bucket?

I'm sorry, but right now it's just eluding me.

Thank you for your help!

Matthew Tallon

[Former Member · Accepted solution]

Done.

[Former Member]

Along with this, I have a related question.

For the solution relating to my main post, I previously used a

Running Total which was an

Average evaluated for

Value not equal zero and

Reset on change of Group2

Is there a way to translate this into a formula?

Thanks

[jyothirmayee_s]

This might help you in detail.

http://stackoverflow.com/questions/8350764/crystal-reports-running-total-for-specific-groups

Let me know if you still face the issue.

Thanks,

Jothi

[jyothirmayee_s]

Hi Matthew,

Did you tried with Running Total?.

Thanks,

Jothi

[Former Member]

Running Total in what manner?

Thank you for your help!