1 Reply Latest reply: May 31, 2013 2:52 AM by Saurabh Pandit RSS

    Set analysis query

    Saurabh Pandit

      Hi all,


      I am facing the following scenario and wanted your guidance.


      I wish to count a field [Work Day Flag]


      Such that all the current selections "do not" affect the count.


      For doing that I can use a simple {1}. But moreover I want certain fields to be included for example [Time bucket]={Current} and [Work Day Flag]={0}.


      I want your help in creating a Expression that will ignore all the current selections and apply the above selections on the Universal Data set for the application.


      All i could try was following: =count({1*<[Time Bucket Type]= {CURRENT},[Work Day Flag]={0}>} [Work Day Flag]) but selections done are changing the count.


      Hope I am clear.

      Feel free to ask if more information is required to help me create the expression..


      Thanks a ton to all for replying.


      Saurabh Pandit