Omitting a time period

[ptrifile]

I have a database that holds data every 15 minutes.....the system does some summing on its own and stores this data at an odd time and never right on the 15 minute mark like the rest of the data....the data looks like this:

12:00:01 1
12:00:01 3
12:00:01 2
12:00:01 6
12:15:04 1
12:15:04 3
12:15:04 2
12:15:04 6
12:30:02 1
12:30:02 3
12:30:02 2
12:30:02 6

and this continues but then for one block of time for a day it will look something like this

11:53:00 10
11:53:00 14
11:53:00 22
11:53:00 9
11:53:00 10
11:53:00 20

This happens at various times depending on the day, I need to understand how to omit anything that is not right on the 15 minute.....is this possible?

Any help is appreciated!

Thanks

Paul

 

[midearth]

Try conditionally suppressing using the following:

minute({TABLE.TIME}) <> [00,15,30,45]

 

[ptrifile]

midearth, thanks for the response, what you suggested doesn't seem to be working. When i look at the detail the "off the 15's" are still listed. Is this because it is a date/time field?

Should i be approaching this differently?

Thanks for the help!

Paul

 

[ptrifile]

Actually now that i look again, this seems to remove all of the 00, 15, 30, 45 time frames doing just the opposite of what i am looking for.

Thanks again,

Paul

 

[midearth]

Are you conditionally suppressing or adding that into your selection criteria? If in your selection criteria, change the <> to = and it should work just fine. I was adding into suppression criteria so it behaved just the same and only showed the 15's.