5 Replies Latest reply: May 14, 2013 9:33 AM by Richard Pressanti RSS

    Distinct Set Analysis

    Bradley Coyne

      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

      4010
      0014010

       

      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