Use Minimum and Maximum Filters on Calculated Columns

Calculated columns, once defined, can be used like any other column. Minimum and maximum filters for calculated columns work in exactly the same way as for the Data Loader Component. See Minimum and Maximum Filters for more information on using them.

Note: Minimum and maximum filters defined for loaded data columns at the component level are used only for that component and do not have any effect on calculated columns.

Calculated data that is filtered out by minimum and maximum filters is reported in the Load Summary Window as missing values, not as filtered values. For example, if you set a filter for a column to filter out values that are zero (or less), then those values are not used in a calculated column that uses that column, and preventing zero divides and Log(0).