You can use these buttons to specify the data to use if certain criteria or conditions are met. You will probably use these buttons in an IF statement that identifies the criteria that, if met, causes a certain outcome. See IF Statements.
And button,
—Inserts an AND statement that enables you to specify multiple conditions that must exist before an outcome occurs. For example, in a composite measure that reflects customer satisfaction, measures for support calls and client references could be used. Specify that high customer satisfaction exists only if there are less than 20 support calls and more than 40 references as follows:IF (mResult (“support calls”)) <20) && mResult(“references”) >40Or button,
—Inserts an OR statement that enables you to specify that one of multiple conditions must exist before something else can happen. For example, in a composite measure that monitors effective product testing, you could use measures that track defects logged by clients and the number of calls to technical support. You can specify that a good level of product testing exists if one of these is true:Less than 100 defects are submitted by clients
Less than 1000 calls are made to technical support
You could define this in a formula as follows:IF mResult(“client defects”)) <100 || mScore( “support calls”) < 1000))
Not button,
—Inserts a NOT statement that enables you to specify conditions that are not true or that should not happen