3 Replies Latest reply: Oct 28, 2016 6:43 AM by Sunny Talwar RSS

    Issue with Variable in Set Analysis

    Deepinder Singh

      Hi,

      I have the below variable defined:

       

      DY= $[Year] (current selection of the Year)

       

      Set Analysis:

       

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

       

      The outcome seems to not work at all. Any help will be much appreciated.

       

      Thank you!