Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have an expression below:
=count({<org_name -= {GetFieldSelections(org_name)}>}patient_region)
In this I am trying to insert a set analysis to ignore the current selection made on the [org_name] field. I keep getting an error. What is the proper expression for it?
Thanks in advance!
Try: count({$<org_name =-{$(=Getfieldselections(org_name ))}>}patient_region)
you can bypass the fields which selections don't want to impact in expression.
=count({<org_name=>}patient_region)
I keep getting an error message in the expression
Yeah, that's a possibility if the org_name I want to ignore is fixed, however, this value keeps changing based on the selections made which is why I am trying to use the GetFieldSelections() expression.
Here's a different approach
If(GetSelectedCount(org_name)=0
,count(patient_region)
,count({$<org_name=E(org_name)>}patient_region)
)