Jeff S
asked on
SSRS Expression Help
I need help writing an SSRS expression.
I need to count the distinct patients where a condition is met. For my example, I want to distinctly count the patients where HCPCLabel = 'Medical'.
Distinct Count PatientProfileId, where HCPCLabel = 'Medical'
I need to count the distinct patients where a condition is met. For my example, I want to distinctly count the patients where HCPCLabel = 'Medical'.
Distinct Count PatientProfileId, where HCPCLabel = 'Medical'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you could use the following expression to set the value to 1 if the field is Medical and 0 if not.
=IIf(Fields!HCPCLabel.Valu
you could then sum the value of the column.
or if your referring to a sql query to get you the total then
Open in new window