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