Conditional exclusion formula

[jlr123]

I have a crystal report that I need to exclude data if condition is met. My formula looks like this but of course does not work. Can you assist me?

{AR_InvoiceHistoryDetail.ItemType} <> "4" and
{AR_InvoiceHistoryHeader.InvoiceDate} = {?Invoice Date Range} and
{AR_InvoiceHistoryDetail.UDF_CC_CODE} = {?CC Code} AND NOT{AR_InvoiceHistoryDetail.UDF_CC_CODE}="OTH")IF (sum({AR_InvoiceHistoryDetail.ExtensionAmt}>0.00)

 

[jlr123]

Actually what I need is a summary formula based on two grouped fields.


IF(GroupName ({AR_InvoiceHistoryDetail.UDF_CC_CODE})= "OTH" AND Sum ({AR_InvoiceHistoryDetail.ExtensionAmt}, {AR_InvoiceHistoryDetail.UDF_CC_CODE})< 0) then sum ({AR_InvoiceHistoryDetail.ExtensionAmt}, {AR_InvoiceHistoryDetail.UDF_CC_CODE} else 0.00

If the GroupName({AR_InvoiceHistoryDetail.UDF_CC_CODE})is anything other than OTH then I need the sum({AR_InvoiceHistoryDetail.ExtensionAmt}, {AR_InvoiceHistoryDetail.UDF_CC_CODE}