Set Functions: The StripCalculatedMembers() Function

In this lesson, we will introduce StripCalculatedMembers(), a basic set function which is often “just what the doctor ordered” in the context of the specific need. The general purpose of StripCalculatedMembers() is to retrieve the members of a specified set, after removing any calculated members.

StripCalculatedMembers() can be leveraged in a wide range of activities, from the support of simple list generation, to the support of sophisticated conditional and other calculations and presentations. We will introduce the function, commenting upon its operation and touching upon creative effects that we can employ it to deliver. As a part of our discussion, we will:

• Examine the syntax surrounding the function;
• Undertake illustrative examples of the uses of the function in practice exercises;
• Briefly discuss the results datasets we obtain in the practice examples.