Need Assistance With formula Syntax

[entertel]

Greetings Tek-Tips

I am working with Crystal version 8.5 and have a question regarding a selective formula syntax

Currently I have this formula in place

{ARN_InvHistoryHeader.InvoiceDate} = {?Invoice Date} and
{IM1_InventoryMasterfile.Category3} in ["122POLY", "122RAY"] and
{IM1_InventoryMasterfile.Category3} = "122POLY" and {ARO_InvHistoryDetail.SOUnitPrice} < 5.85 and
{IM1_InventoryMasterfile.Category3} = "122RAY" and {ARO_InvHistoryDetail.SOUnitPrice} < 8.05 and
{POO_PurchaseHistory.VendorNumber} in ["0037555", "0543225"]

I get ZERO data return, however if I remove the

and
{IM1_InventoryMasterfile.Category3} = "122RAY" and {ARO_InvHistoryDetail.SOUnitPrice} < 8.05

I will get that results for the

{IM1_InventoryMasterfile.Category3} = "122POLY" and {ARO_InvHistoryDetail.SOUnitPrice} < 5.85

Can you help?

Thank You,
Lisa

 

[AndyMc]

Try:

{ARN_InvHistoryHeader.InvoiceDate} = {?Invoice Date} and
(
({IM1_InventoryMasterfile.Category3} = "122POLY" and {ARO_InvHistoryDetail.SOUnitPrice} < 5.85) or
({IM1_InventoryMasterfile.Category3} = "122RAY" and {ARO_InvHistoryDetail.SOUnitPrice} < 8.05)
) and
{POO_PurchaseHistory.VendorNumber} in ["0037555", "0543225"]

Andy