on 02-07-2005 12:39 PM
I have an issue with result-rows not showing in my query. I have three characteristics in my rows; PO-group, Vendor, and material. Then I have some formulas and KFs as columns. For vendor and marial I have ticked in "always supress result rows" in the properties. In the KFs/formulas that I want to sum I have ticked in "calculate result as... summation":
Query currently:
POGroup Vendor Material Formula
1 1 A 10
1 1 B 10
2 1 A 10
Query wanted:
POGroup Vendor Material Formula
1 1 A 10
1 1 B 10
RESULT. 20
2 1 A 10
RESULT. 10
Best Regards
/Daniel
You need to suppress result row 'Never' on the vendor:
If you don't suppress PO group you get
POGroup Vendor Material Formula
1 1 A 10
1 1 B 10
2 1 A 10
RESULT. 30´
If you don't suppress vendor you get
POGroup Vendor Material Formula
1 1 A 10
1 1 B 10
__RESULT. 20
2 1 A 10
__RESULT. 10
If you don't suppress vendor and POgroup you get
POGroup Vendor Material Formula
1 1 A 10
1 1 B 10
__RESULT. 20
2 1 A 10
__RESULT. 10
RESULT. 30
Best regards
Dirk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Daniel
For the material "never suppress result row"
alessandro
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
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.