on 07-17-2018 9:12 PM
Hi - I have multiple queries pulling data into a BOBJ report. The columns in the report are order number, order line number, vendor, and dollar amount. I need the dollar amount field to represent the total dollars for that vendor on that order number. Currently it is obviously providing me only the dollars for that line number. I've tried "For Each" but have been unsuccessful. So if line # 10 for Vendor ABC is $100 and line #12 for Vendor ABC is $100 - I need the dollar value column to aggregate both lines for that vendor and display $200 on line 10 and $200 on line 12. Can anyone offer any assistance? Thank you!
use IN operator.
=sum(amount) in (vendor)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.