Distinct Set Analysis

[#1]

Hi!

i would like to setup the follwing set analysis statement for calculation.

i have three objects;

1Artikel.Artikelnr

2Artikel.Stocklevel

3.Artikel.Listprice

In my QV app Artikel.Artikelnr can appear multiple sames on the same nr.

Artnr	Stocklevel	Listprice
001	40	10
001	40	10

there my calculations are wrong,  it should be 400 not 800.

so what i am trying to achieve is the following

sum(distinct(Article.Artikelnr(Artikel.Stocklevel * Artikel.Listprice))

it is however still returning values that are too high.

is there anotherway to wrtie the statement, set analysis perhaps that can be used in a pivot table and still be dynamic?

Best,

Bradley

[jagan]

Hi,

Remove the duplicate rows in script by using

LOAD DISTINCT

*

FROM Datasource;

OR

Use this expression

sum(Aggr(Max(Artikel.Stocklevel) * Max(Artikel.Listprice), Article.Artikelnr))

Hope this helps you.

Regards,

Jagan.

[#3]

Try

avg(Artikel.Stocklevel * Artikel.Listprice)

or

sum(Artikel.Stocklevel * Artikel.Listprice) / count(Article.Artikelnr)

[#4]

try this

Aggr(sum(Artikel.Stocklevel * Artikel.Listprice), Article.Artikelnr)

[#5]

Thanks for the reply.

However this did not solve our problem;

i have pasted a picture to show you the phenomenon we are facing

[rlp · Accepted solution]

Try this:

Sum(

     Aggr(

          DISTINCT

          Max(Artikel.Stocklevel) * Max(Artikel.Listprice)

          ,

          Article.Artikelnr

          )

)