Remedy Smart Reporting - How to use a calculated field as a filter for null values

Knowledge Article

Article Number

000386368

Old Article Number

Article Type

FAQ/Procedural

Title

Remedy Smart Reporting - How to use a calculated field as a filter for null values

Summary

Using a calculated field as a filter for null values

Product

Remedy AR System Server

Component

Smart Reporting Remedy

Applies to

Remedy Smart Reporting

Question

How to use a calculated field as a filter to show only required rows of a filtered column?

Answer

Into the Report, identify the values in the column from which certain rows are required to be displayed
Create a new Calculated Field.
Type a Calculated Field Name.
Set Formula Type as Simple and the Resulting Field Type as Text
Configure the desired values to filter on the empty box as follows:
Example:
CASE WHEN Status = 'Closed' THEN 'Null' ELSE 'NotNull' END

6. Click the Save button instead of the Validate button because the Validate has a defect when using it and may detect the CASE statement with a syntax problem.
7. Back on the report, drag the calculated field created and the column to filtering to the Filter box

8.Clic on Advanced Settings
9.Set the column as Equal to, and the Calculated Field as In List, then close the Configure Filters

8.Move to Design
9.On the Filter menu on the left, select the value to be displayed, and click on Summit

Attachment(s):