The FORMAT_STRING property is used for specifying how a regular or calculated member (usually a measure) should be presented and what its FORMATTED_VALUE should look like. There are some predefined formats such as Standard, Currency or Percent, but we can also specify our own using the right combination of characters.
Most people are unaware of the fact that there are actually 4 sections of the format string for numeric values and 2 sections for strings. In this recipe we'll see how to set the format for negative, zero, or null values.
Follow these steps to set up the environment for this recipe: