Summing Displayed Records ONLY

[arachnoid]

I am suppressing records based on a particular criteria and I am wanting to only sum the records that are being displayed at a group level.

Any suggestions??? I have been slamming my head against my desk for nearly two days now and its really starting to sting...

Any help will be greatly appreciated.

 

[2techie]

Hi,

Create a running total. In running total you have so many options of summing / supressing on a group.

Also display some example data so that some body here can help you.

Hope that helps.

Vishal

 

[synapsevampire]

You can use a Running Total and in the Evaluate Use a Formula, place the reverse of your suppression formula.

Or you can use the three formula approach, wh3erein you create a initialize a variable in the group header, sum at the details, and display at the group footer.

Or you might omit the rows from the report entirely by using the Report->Edit Selection Formula->Record and placing the equivalent to the suppression in there.

-k

 

[lbass]

I was following your previous thread, but didn't respond because there wasn't enough information, and it appears that your issue is still unresolved. Please post more specifics: your suppression formula and your running total formula (or if you are using the wizard, the details of the field you are summarizing, on change of what, reset on change of what, and then maybe someone will be able to protect both your head and your desk!

And I think you'll get some quick results!

-LB

 

[arachnoid]

My issue from yesterday has been resolved; however, this issue is with the same report, just a different field.

I am attempting to perform this summary with the 3 formula fields method.

Formula 1

whileprintingrecords;
numbervar qtyord;
qtyord := 0

Formula 2

whileprintingrecords;
numbervar qtyord;
qtyord := qtyord + Sum ({F4211.SDUORG}, {F4102.IBPRP7})

Formula 3

whileprintingrecords;
numbervar qtyord;
qtyord

My suppression is based on another formula, {@Need for Orders and Max Packaging} that is comprised of another formula, that is why I cant simply select this field using the select expert and say {@Need for Orders and Max Packaging} > 0.

The only reason I am even attempting to use the 3 formula method on this Qty Ordered field is because of the suppression that I have for {@Need for Orders and Max Packaging}. I am suppressing any records in the Group #2 Header {@Need for Orders and Max Packaging} <= 0, and I am now attempting to sum the displayed records for the Qty Ordered field only.

Thanks again.

 

[lbass]

So now we just need to know the contents of {@Need for Orders and Max Packaging} and what your group structure is--is {F4102.IBPRP7} your group2 field?

-LB

 

[arachnoid]

Contents of {@Need for Orders and Max Packaging} is

{@Need to Pack for Orders}+{F4102.IBSAFE}

{@Need to Pack for Orders} = Sum ({F4211.SDUORG}, {F4102.IBPRP7})-{F41021.LIPQOH}

Yes, {F4102.IBPRP7} is the structure for group #2

 

[lbass]

You should be able to use the group select by changing your formula to a lower order one:

Sum ({F4211.SDUORG}, {F4102.IBPRP7})-{F41021.LIPQOH}}+{F4102.IBSAFE}>0

You would still need the running totals though, since the underlying data would contribute to the usual type of summaries, e.g., counts, etc.

-LB

 

[arachnoid]

Thanks!!!