7 Replies Latest reply: May 12, 2017 5:05 AM by Kristian König RSS

    Count Distinct based on positive sum - Expression

    Kristian König

      Hello,

       

      i've got a small problem and i am hoping somebody can help me.

       

      There are 3 parameters in my table:

       

       

      BuyerŠifra artiklaNeto
      A123 4200
      A123 4-200
      A567 8300
      B567 8200
      B123 4100

       

      This is my formula: count(DISTINCT{<NETO = {">0"}>}[Šifra artikla])

       

      Basically the formula Counts the "Šifra artikla" where Neto is >0 per Buyer.

      BuyerCount
      A2
      B2

       

      Now the problem is, i don't want that. I want the formula to count where sum of neto per "Šifra artikla" is >0, so that the final result is:

       

      BuyerCount
      A1
      B2

       

      Help appreciated.

       

      Thank you.