22 Replies Latest reply: Jan 13, 2017 7:27 AM by Eduardo DImperio RSS

    Problems with set analysis

    Juan Carlos Vera Hernandez

      Hello,

       

      I need to show a column in a Pivot Table wich counts some rows depending on a condition:

       

      the formula is:  Count(Distinct  {$<[$(variable1)+$(variable2)]= {'>0'}>} [CommercialSite])

       

      So I want to count comercial sites that variable1 greater than 0 and variable2 greater than 0. This sentence is not working because is counting all rows as if no condition is set.

      I have checked the syntax and for me is ok, Can anybody help me with this?

       

      Thank you very much.