19 Replies Latest reply: Mar 5, 2018 9:29 AM by Amit Saini RSS

    Count help?

    Amit Saini

      Dear All,

       

      I'm having below case:

       

       

      One line cab belong to different stations , in above case it is 3.

       

      So what I'm looking for is count of "Global Station Label" but need to include line count too.

       

      As of now I'm using below expression:

       

      =count(DISTINCT {<Month=,Week=,Day=,Type_Name=,Why_Name=,Standard_Name=,Technology-={'No Fuel BM','No SCR inj'}>}Global Station Label)

       

      How should I include here count of line???

       

      I'm not looking for simply * above expression with count(Line) , I need somehow "And" condition to consider both factors.

       

      Please suggest!

       

      Regards,
      AS