[RESOLVED] A Number or Currency Amount is Required Here

[Vacation]

I am running Crystal Reports 10.

My formula is as follows:
{Subscriptions.PAYMENT_AMOUNT} <> ['0.00', '465.00', '515.00']

but I am getting the error "A number, or currency amount is required here."

This is a number field, from what I can tell, but obviously, I'm missing something.

Thanks for any help.

[jggtz]

Try with :

Not {Subscriptions.PAYMENT_AMOUNT} In [0.00, 465.00, 515.00]

I suspect that the field is numeric type

[Vacation]

Thanks for the response.

When I try this it is telling me that "a boolean is required here" and highlights the field name.

[jggtz]

My mistake!

Not ({Subscriptions.PAYMENT_AMOUNT} In [0.00, 465.00, 515.00] )

[Vacation]

That's it! Thank you so much for your help.

Have a great day.

[Lennie]

Hi Good Guys,
Using VBNET2008 and Northwind database ORDERS Table.

I am experiencing similar problem of trying to display total FREIGHTS under the same CUSTOMERID. The Crystal Report GroupHeader Section is based on CUSTOMERID.

under the GroupFooterSection this formula :
Sum([DataTable1.Freight}, {DataTable1.CustomerID})

Generate this Error message while in the processing of creating it:-
A number field or currency amount field is required here

In the SQL SERVER 2000, the ORDERS table
The column FREIGHT datatype is MONEY

Please help me, I need your help.

Thanks,

Cheers,
Lennie