Brian the Fish
New member
- Local time
- Yesterday, 23:08
- Joined
- Feb 28, 2010
- Messages
- 2
I am creating a report and the output should group payments by the vendor and then by the absolute value of the payments. I have done this by creating this grouping expression:
Abs(GrossAmt)
What I cannot figure out how to do in the report is to eliminate the payments with only one amount. For example, if my payment amount look like this:
-3
1
1
3
5
My report output should show:
-1
1
3
3
The amount 5 should not show.
I tried to create a query that counted the Abs value of each amount by vendor and then bring that into the report with the parameter that the count is > 1, but it is not working. Can anyone out there help?
Abs(GrossAmt)
What I cannot figure out how to do in the report is to eliminate the payments with only one amount. For example, if my payment amount look like this:
-3
1
1
3
5
My report output should show:
-1
1
3
3
The amount 5 should not show.
I tried to create a query that counted the Abs value of each amount by vendor and then bring that into the report with the parameter that the count is > 1, but it is not working. Can anyone out there help?