CR9 - Add Group Count

[Brian555]

I have created a report based on an Excel worksheet that contains 3 columns, “Order Number”, “Order Status” and “Cancel Code”.

I have grouped the report by the 3 columns; Group 1 = order number, group 2 = order status and group 3 = Cancel code.

I have inserted a Count Summary in the Group 2 Header that counts the 4 order status’s per order number. The order status’s being “Live”, Fully Paid”, Successful” and “Cancelled”.

What I am having difficulty doing is creating and placing a formula that adds the “Fully Paid” count to the “Successful Count”.

CAN ANYBODY HELP PLEASE?

 

[lbass]

Create a formula:

if {table.orderstatus} in ["Fully Paid","Successful"] then 1

Place this in the detail section and right click on it and insert a sum (not a count) at the Group #1 level. You can drag this summary into the GH#1.

-LB