Conditional formatting in Jedox
The majority of reports developed in Jedox for analysis purposes use the tabular format. It is the easiest way to display the data and detect patterns. Like in Excel, Jedox can provide conditional formatting functionality. Since most of the users are familiar with the concept of conditional formatting, here are some examples of how you could combine it with some Jedox formulas. Fo the ones who are not please check the following link here.
In the first example, we are going to show you how to format every second row. For this purpose, we will use the excel function ROW() and then detect if the row number is odd or even number.
In the second example, we will show you how to color only base elements. Usually, this type of formatting is used when Bottom-UP planning is performed.
Sometimes users would like to see MAX and MIN value elements in the same row. An example of that can be found below.
Since the planning...
