Result-row not showing in query!?

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Thanks!

[Former Member]

Daniel

For the material "never suppress result row"

alessandro