[RESOLVED] Formula Help CR11

[Besoup]

Hey,
I am looking to sum up the Retail Price column of my Detail for only 2 Different Styles on my Invoice.

So say there are Style number 50 and 51 on my invoice, I need to total the retail on thier lines. Is there a way to do this in a formula?

Ex.

Style# - Retail Price
50 - 12$
39 - 19$
11 - 62$
51 - 26$
50 - 12$

Sum of 51's and 50's = 50$

[brucevde]

You could use a Running Total field. I only have CR 8.5 but will assume the steps are the same in CR 11.

Open the Field Explorer and create a Running Total.

Set Field To Summarize = Retail field
Type of Summary = Sum

Evalute section, select Use Formula option and enter
{Style} = 50 Or {Style} = 51

Reset section, select Never if you want a Grand Total.

Save and place running total field on the report.

[Besoup]

Thanks man!