Grouping/summing on sum

[smeyer56]

I am using CR10.
I am trying to create a report on ticket sales to show the average sale on tickets that use coupons.

I have created a variable that if a line item shows a coupon, it gives that variable a value other than zero. IE Radio Coupon = 1. Since only one coupon can be used per ticket, summing this value give me a way to designate the ticket using a certain coupon or not using a coupon.

The problem is that now I need to create a group on this variable so that I can add the total tickets with each value and the ticket $ in order to create the average sale.

I seems that CR will not let me create a group on a sum.

Is this possible?


Group 1 - Store
Group 2 - Coupon type
Group 3 - Ticket Number
Details - Line items
Group 3 Footer - Sum of variable for Coupon type
Group 2 Footer - Group & Sum of Group 3 for Ave sale calcs

 

[lbass]

Why not just use a conditional formula:

if not isnull({table.coupon}) then 1

You could insert a group on this, or place this in the detail section and insert summaries on it. For amounts, you could use a conditional formula like:

if not isnull({table.coupon}) then {table.amt}

//etc.

-LB

 

[smeyer56]

That was perfect. Thanks!