Date: Fri, 29 Mar 2024 05:31:15 -0600 (MDT) Message-ID: <277688015.2855.1711711875800@confluence-external-wiki> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_2854_515175062.1711711875800" ------=_Part_2854_515175062.1711711875800 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The most important reason for creating a Conditional Format is to assist= an end user to interpret the data presented to them. You can create rules = to highlight or change the appearance of data on your report and chart= s.
It is recommended that Conditional Formats be used whenever the reader o= f a report needs to be drawn to act or interpret data based on a pre-determ= ined set of rules.
You can create conditional formatting rules for your report columns as w= ell as your widgets. To learn more about these, click on the options below:=
When inserting values into the Conditional = Format type a number of rules need to be followed. These include:
If you are creating a number of Conditional Formats, as in the example a= bove, care will have to be taken to ensure that the Conditional Format valu= es do not overlap. For instance you cannot set one record that is 50 to 60 = and another 55 to 65. This will cause a clash in processing and may result = in your report failing.
When creating a range of values =E2=80=93 such as for a BETWE= EN operator the lower end variable must be inserted as the firs= t value of the Conditional Format followed by the higher. Example =E2=80=93= 30 then 40 not 40 then 30. If this is not followed you report Conditional = Format will fail since no data will meet the criteria.
You do not have to create a Conditional Format for every possible value = that will be returned. If there is a measure that does not meet a Condition= al Format criterion it will be returned in a normal font. Conditional Forma= ts should only be put on values that you want to draw attention to.