I have a WebI report that is filtering on several fields. One of the filters uses a 'Less than or Equal to 2' condition.
A lot of the records have an empty string (not a null) for this field. The report is ignoring them, but it needs to include them.
Is there a way I can modify the WebI filter to include the empty strings? Or is there a way that the BeX Query can be modified to convert these values to zero?
Thanks for your help!