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!