This is my first post and I appreciate everyone’s help.
I have two rows in my report having same transaction number.
The differentiating factor is the account number. In one of the rows the amount is 0 and in another row the amount is coming from a valid expected account.
The amount 0 is generated as there is :
Transaction# Account# Amount
100100 200210 +50
100100 200210 -50
in the table and is aggregated togehter.
How can I delete the line with amount 0? I tried adding a filter in the query to avoid any rows with amount=0, but since there is a value i.e.+50 or -50 which causes the row to be aggregated and appear in the report.
I would think that your measure would be defined as Sum(Amount). Then you could just filter the query. You would end up with a Having clause, so it could be slow.
Otherwise, just put a filter on the report for the Amount column and show any that are not equal to 0.
As told by steve, you can not delete a row,you have to apply a report filter
sum(amount) foreach account.Try this may work and the apply filter in report.
Thanks,
Madhu.
Your answer set has 2 rows where the measure for each has some variable that differentiates it - so that they won’t combine and zero out.
You can put a Report Filter on the block containing these to eliminate where Sum(measure <>0)
or
You can do a sub query to eliminate all rows summing to zero before returning the answer set - especially if you are having to count
ex.
Account <> Account
where Measure = 0
(BOB member since 2002-06-25)