Printable View
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$
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.
Thanks man!