This content has been marked as final. Show 5 replies
i would like to setup the follwing set analysis statement for calculation.
i have three objects;
In my QV app Artikel.Artikelnr can appear multiple sames on the same nr.
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?