Category / Section
How to show only records that have a value greater than zero in at least one column in a grid widget?
Published:
In certain use cases, we should display data greater than zero in at least one column. In order to accomplish that, we need to generate an expression that includes all relevant columns and then apply a filter based on it.
Please refer to the detailed demonstration provided below.
Step 1:
Generate the expression using all necessary columns to return zero if all the columns are zero.
Step 2:
Add the expression to the filters tab in the assign data panel of the grid widget.
Step 3:
Apply filter as Expression greater than zero.
As a result, the data in the grid will be filtered to display only values where at least one column has value greater than zero.
Related Links
PK
