Expression to use in chart in order to exclude certain values to be counted

Expression to use in chart in order to exclude certain values to be counted

Posted by: lize-marie on 9 May 2018, 8:59 pm EST

• 

  lize-marie

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 May 2018, 8:59 pm EST

  I am trying to define the value for one of the series values in my chart. I would like the value that is calculated to only count the number of employees for which a certain condition exists. I have tried the below expressions:

  Count(iif([TrainingCategoryID] = 2 , [EmployeeNo], 0)
  
  Iif([TrainingCategoryID] = 2, count([EmployeeNo],0)
  
  Count([EmployeeNo] where [TrainingCategoryID = 2)

  But all of them give me the total number of employees if the condition was met in any 1 of the lines in the dataset.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 13 May 2018, 8:52 pm EST

  Hello,

  You can use the expression in the series value to count the number of employee according to some condition. Please refer the following expression:

  =IIF([SupplierID] Mod 2 = 0, [ProductID],0)

  Also, please refer the attached report to implement the same.

  Hope it helps.

  Thanks,
  
  Mohit

  Chart.zip