Filter report in Infomaker 11.5

[e***@hotmail.com]

I am using Infomaker 11.5 to create a report with multiple columns. I
would like to compare two columns and if the amounts in each of those
rows are the same, I would like to filter those rows out. I can use
the Rows>Filter dialog box and enter the formula: column 2 <> column
7 which works fine except that I would like to NOT filter out those
rows where column 2 = .00 and column 7 = .00. I would like those rows
to stay.

Any ideas?

Thanks,
ebartscher

[Chris Pollach]

Hello;

Just add a NOT to the filter ...

NOT column 2 <> column > 7
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

Post by e***@hotmail.com
I am using Infomaker 11.5 to create a report with multiple columns. I
would like to compare two columns and if the amounts in each of those
rows are the same, I would like to filter those rows out. I can use
the Rows>Filter dialog box and enter the formula: column 2 <> column
7 which works fine except that I would like to NOT filter out those
rows where column 2 = .00 and column 7 = .00. I would like those rows
to stay.
Any ideas?
Thanks,
ebartscher

[Chris Pollach]

Sorry;

I should of read that more carefully ... I would code that as follows:

(column2 <> column7) and ( (column2 = .00) or (column 7 = .00) )
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

Post by e***@hotmail.com
I am using Infomaker 11.5 to create a report with multiple columns. I
would like to compare two columns and if the amounts in each of those
rows are the same, I would like to filter those rows out. I can use
the Rows>Filter dialog box and enter the formula: column 2 <> column
7 which works fine except that I would like to NOT filter out those
rows where column 2 = .00 and column 7 = .00. I would like those rows
to stay.
Any ideas?
Thanks,
ebartscher

[Terry Dykstra [TeamSybase]]

I interpret your statement slighlty differently than Chris. I would use:

(column2 <> column7) or (column2 = 0 and column 7 = 0 )
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

Post by Chris Pollach
Sorry;
(column2 <> column7) and ( (column2 = .00) or (column 7 = .00) )
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

Post by e***@hotmail.com
I am using Infomaker 11.5 to create a report with multiple columns. I
would like to compare two columns and if the amounts in each of those
rows are the same, I would like to filter those rows out. I can use
the Rows>Filter dialog box and enter the formula: column 2 <> column
7 which works fine except that I would like to NOT filter out those
rows where column 2 = .00 and column 7 = .00. I would like those rows
to stay.
Any ideas?
Thanks,
ebartscher

[e***@hotmail.com]

On Apr 3, 12:02 pm, "Terry Dykstra [TeamSybase]"

Post by Terry Dykstra [TeamSybase]
(column2 <> column7) or (column2 = 0 and column 7 = 0 )
--
Terry Dykstra (TeamSybase)http://powerbuilder.codeXchange.sybase.com/http://casexpress.sybase.com
product enhancement requests:http://my.isug.com/cgi-bin/1/c/submit_enhancement

Post by Chris Pollach
Sorry;
(column2 <> column7) and ( (column2 = .00) or (column 7 = .00) )
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

I am using Infomaker 11.5 to create a report with multiple columns.  I
would like to compare two columns and if the amounts in each of those
rows are the same, I would like to filter those rows out.  I can use
the Rows>Filter dialog box and enter the formula:  column 2 <> column
7 which works fine except that I would like to NOT filter out those
rows where column 2 = .00 and column 7 = .00.  I would like those rows
to stay.
Any ideas?
Thanks,
ebartscher- Hide quoted text -

- Show quoted text -

I got the results I wanted with this one: (column2 <> column7) or
(column2 = 0 and column 7 = 0 ) I was surprised that they both didn't
work. I do appreciate both of your replies. It is a rather complex
report to have to trash because of not being able to filter it.

Thanks again,
embartscher