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