Filter Error on CALCSUMS

poppins

Hi everyone,

I am trying to set some filters on a report, among them this location filter: F*
In the report there is this piece of code:

ValueEntry.CALCSUMS("Valued Quantity");

I get the following error when I run the report:

The sum of the values in the Valued Quantity field cannot be calculated because the filter contains question marks (?), asterisks (*), or 'at' symbols (@). 

Is the (*) forbidden for CALCSUMS?
How shall I do?

Thanks in advance

neilgf

Hi,
Yes you cannot use wildcards but you can use a range. So for, say, a filter DA* you can include under setrange DA00001 and DA999999.
Just an example. A 'feature' of Nav.
Neil