...
Example: Assume we want to display purchase order values in an OLAP Table column. Depending on whether the purchase order is above 500.000, between 350.000 and 500.000 or below 350.000, values should be displayed in green, orange or red. For this purpose, we will insert the following nested IF function into the “Font Color” field given in the configuration options for the OLAP Table: =IF($value>500000;'red';IF($value<350000;'green';'orange')). The system will check the condition $value > 500.000 at first. If it is true, the value will immediately be displayed in red. If it is false, the system will enter another IF function checking if the value is below 350.000. You could also use some more IF functions as substitutes for the final values “red”, “green” and “orange”, thus allowing for an even finer formatting granularity depending on the height of the order value. An example for the nested function’s output can be seen in Figure 3.2123.
Figure 3.2423: Nested Functions