1 Reply Latest reply: Oct 5, 2011 2:51 PM by Michael Solomovich RSS

    Matching several values in Set analysis

    Georgina Spary

      Hello folks. I've written some set analysis. This counts students only where the [Module Compulsory Prog] field matches a single [Programme Code] field selected.

       

      = Sum ({$<[Module Compulsory Prog]={$(=[Programme Code])}>}[Student Count])

       

      How can I get it to work when I select multiple [Programme Code] fields - i.e count students where [Module Compulsory Prog] matches any of a selection of [Programme Code] fields?

       

      Thanks in advance

       

      George