Conditions act as intelligent editors, operating on an
"if-then-else" principle
enhancing flexibility in customizing report data presentation. They don't skip records that don't meet the criteria but rather help display their data in a relevant manner.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/3604669/1698935003946-conditions.png)
Dynamic Text and Date elements can be assigned with conditions, which become available once the field is mapped. Here's how it works:
- Clicking the "Add Conditions" button opens the Conditional Values popup, where the selected field is designated as "IF" and cannot be altered.
- The next field sets the condition for processing, such as "equals," "is not equal," "contains," and more, depending on the field type.
- The subsequent field is for specifying the value used to trigger the condition. This value should be manually added based on the requirement.
- The "Then" field can remain empty or be manually assigned a value. This value replaces the database value when the condition is met.
- "Else" determines what should be displayed if the condition is not met. By default, it's set to "Database Value," but it can be replaced with a custom value.
Here's how Text-type fields' conditions function:
- The "Equals" condition only processes records that exactly match the entered value in the conditioned field. It's case-sensitive, so the value must match the database case.
- The "Is not equal" condition processes records that do not exactly match the entered value in the conditioned field. The match must be exact, and it's also case-sensitive.
- The "Contains" condition processes records that contain the value entered in the conditioned field. An exact match isn't necessary, and it's not case-sensitive.
- The "Does not contain" condition processes records that do not contain the entered value in the conditioned field. An exact match isn't required, and it's not case-sensitive.
- The "Is blank" parameter handles records with an empty conditioned field.
- The "Is not blank" parameter handles records with data in the conditioned field.
Number-type fields have these conditions:
- The "Equals" condition only processes records that exactly match the entered value in the conditioned field.
- The "Is not equal" condition processes records that do not exactly match the entered value in the conditioned field.
- "More" processes values greater than the entered number (without including it).
- "Less" processes values less than the entered number (without including it).
- "More than or equal to" processes values greater than or equal to the entered number.
- "Less than or equal to" processes values less than or equal to the entered number.
- "Is blank" and "Is not blank" work as they do for text fields.
Date-type fields have the following conditions:
The tutorial is created based on the Sunday-Saturday week type.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172908/Screenshot_1.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172906/Screenshot_2.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172913/Screenshot_3.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172917/Screenshot_4.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172912/Screenshot_5.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172909/Screenshot_6.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172905/Screenshot_7.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172910/Screenshot_8.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172904/Screenshot_9.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172907/Screenshot_10.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172911/Screenshot_11.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172914/Screenshot_12.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172915/Screenshot_13.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172918/Screenshot_14.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172921/Screenshot_15.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172916/Screenshot_16.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172919/Screenshot_17.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172920/Screenshot_18.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172923/Screenshot_19.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172924/Screenshot_20.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172925/Screenshot_21.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172922/Screenshot_22.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172926/Screenshot_23.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172927/Screenshot_24.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172932/Screenshot_25.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172931/Screenshot_26.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172930/Screenshot_27.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172928/Screenshot_28.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172933/Screenshot_29.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172929/Screenshot_30.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172940/Screenshot_31.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172936/Screenshot_32.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172935/Screenshot_33.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172934/Screenshot_34.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172938/Screenshot_35.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172937/Screenshot_36.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172941/Screenshot_37.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172950/Screenshot_38.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172939/Screenshot_39.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172943/Screenshot_40.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172944/Screenshot_41.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172942/Screenshot_42.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172947/Screenshot_43.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172946/Screenshot_44.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172945/Screenshot_45.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4172949/Screenshot_46.png)
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/10540/4175127/Screenshot_48%2BFIX.png)