Filtering out rows that contain SUM(Period Change)=0

This article details how to filter out rows that contain SUM(Period Change)=0.

Method

If you want to filter out rows that contain SUM(Period Change)=0, it will not work if you are using Period Change <> 0.

You can do the following:

1. Insert two Period Change parameters.
2. In the first one, select the Less than (<) operator and enter -1.
3. In the second one, use the OR operator, the Greater than (>) operator, and enter 1.