Running-Count or Count with Expression

[bioCam]

Hi, I am adding New Query Items 'RC-Complaint_1', 'RC-Complaint_2', 'RC-Complaint_3' to the Query Subject. 

'RC-Complaint_1' --> count the number of occurences of Complaint Type with data value 1 for that customer.  My scope is both the Customer and where the Complaint Type = 1

'RC-Complaint_2', 'RC-Complaint_3' would be for Complaint Type = 2 and 3 respectively.

In my expression definition:-

running-count( 0 for Customer,  Complaint Type] =1)  ---> the syntax I think is wrong and is not working for me.  I am not getting much luck searching for examples.  Would anyone know a solution?  Thank you.

[blom0344]

A running-count is used for a different purpose. Normally the expression would be something like:

Code Select Expand


CASE
WHEN
Complaint Type = 1
THEN 1 ELSE 0
END


Set the aggregate to sum and then use both the customer and this new fact into the report