If GroupName not starts with then sum

[jlr123]

Basically, I am trying to sum a field in Crystal and it is not working. I am placing it in the Report Footer. If the groupname SalespersonNo is not like ZZ* then sum the extension amount.
if not ((GroupName ({AR_Customer.SalespersonNo})like "ZZ*")) then Sum ({AR_InvoiceHistoryDetail.ExtensionAmt}, {AR_Customer.SalespersonNo})

Can someone tell me what is wrong please?

Thanks so much.

 

[kray4660]

What is happening (that is wrong)?

 

[jlr123]

It gives me total of 0 and should be a value > than 0. But this is not urgent now. thanks.

 

[pmax9999]

Using a Group formula in the report footer won't work.

One option is to use a running total summing the Extension Amount, evaluating on the formula:

Not{AR_Customer.SalespersonNo} like "ZZ*")

Altenratively, create a formula like the following, and use a Summary to sum it:

If 	Not ({AR_Customer.SalespersonNo} like "ZZ*") 
Then 	{AR_InvoiceHistoryDetail.ExtensionAmt}

Hope this helps

Cheers
Pete