if you want it to return TRUE whenever the first 2 options are both 0 OR the last 4 options are all 0
then i think this:
(
Sum (
{@Recurring?}, {AR_Customer_System.Customer_System_Id}) = 0.00 and
Sum (
{@Equip Date older than 5 years}, {AR_Customer_System.Customer_System_Id} = 0.00)
)
or
(
Sum (
{@Recurring?}, {AR_Customer_System.Customer_System_Id}) = 0.00 and
Sum (
{@No Parts just Null}, {AR_Customer_System.Customer_System_Id}) = 0.00 and
Sum (
{@Warranty older than 5 years}, {AR_Customer_System.Customer_System_Id}) = 0.00 and
Sum (
{@Contract Start Date older than 5 years}, {AR_Customer_System.Customer_System_Id}) = 0.00
)
IP Logged
