5 Replies Latest reply: Feb 24, 2015 6:01 PM by Deepinder Singh RSS

    Intersection in set analysis

    Deepinder Singh

      Hi,

       

      I am trying to develop report showing all suppliers belonging to two Diversity Categories:

       

      Sum({$<[DIVERSITY DEFINITION]={'SMALL BUSINESS'} AND {'DISADVANTAGED BUSINESS'}>}[Line Amount])

       

      The "AND" operator as used above does not work ofcourse.

       

      Please note that the expression:

      Sum({$<[DIVERSITY DEFINITION]={'SMALL BUSINESS', 'DISADVANTAGED BUSINESS'}>}[Line Amount])


      is an "OR" operation which includes all Vendors with either Diversity Definition. This is not what I need.


      Thank you!