Assigning current selection to a filed

[#1]

Hi,

i am capturing the current selection in a variable

like below to get the current Selected SURGEON name.

vSurgeon=GetFieldSelections(SURGEON)

I am using this variable in  another expression to get the count of cases in which the selected SURGEON was an ASSISTANT_SURGEON

='Case Count (Assist Surg): ' & (num(count({<ASSI_SURGEON ={'$(=vSurgeon)'}>}distinct CASEID)))

but this is giving me the result as 0.

Note: A SURGEON cant be a an ASSISTANT SURGEON at same time. Could this error since when I select the SURGEON Name it will  grayed out form the List of ASSISTANT SURGEON?

Any way on hard coring the the surgeon name in the expression I am getting the correct result.

=count({$<ASSI_SURGEON = {'ROBERT S'}>}distinct CASEID).

Does someone have any idea on this?

Thanks

Saritha Xavier

[swuehl · Accepted solution]

I see two issues here:

Your variable does not enclose all values in single quotes, per value. So if you select more than one SURGEON, you element list will not be formatted correctly.

If selections in SURGEON and ASSI_SURGEON are incompatible, you need to clear selection in SURGEON when assigining a set to ASSI_SURGEON.

I would try it like

=count({$<ASSI_SURGEON = SURGEON, SURGEON =>}distinct CASEID).

[#3]

Thanks Swuehl, this solved my issue.