5 Replies Latest reply: May 22, 2012 5:02 AM by Deepak Vadithala RSS

    Set Analysis

    hkgandhi

      Hi,

       

      I am building a dashboard which requires an object to display value according to fixed constraints, so even if i make selection in the adjacent charts/filter objects it should not change its value on any selection made in the work sheet.

       

      here is what i am using :

      =count(distinct (if (Status = 'Active' or Status ='Waiting for Resolution'), [Counter Incident Number])))

       

      Regards,

      H