Skip to Content
0
Former Member
May 19, 2010 at 12:38 PM

Eliminating or filtering records in Crystal Prof 11.5.11.1470

24 Views

Hi all,

I am trying to filter/suppress/exclude records from a formula where fields include data that looks like the following vs records that hold a dd/mm/yyyy format:

//

0.00049751243781

0.00049776007964

0.00049800796813

0.00049825610364

0.00049850448654

0.0005

0.00050226017077

1/-1/2009

1/1/2010

1/-1/2010

Can anyone help me? Specifically, when trying to exclude //, crystal sees this as a comment. I tried to use like 0. and it is looking for a string, and, I have no idea how to exclude the dates with the dash in them.