Inhibitions in Applying Null-Based Filters to Dimensionally-Driven Tabular Data with Multi-Period Measures
Within the confines of my application, I possess a tabular structure that encompasses several dimensional attributes accompanied by three distinct quantitative measures. These measures are delineated as follows: (1) Current Period—indicative of the monetary sum presently available, contingent upon a period-specific selection variable; (2) Compared Period—representative of the financial holdings during a previously selected temporal interval, determined via a distinct variable; and (3) Difference—calculated as the delta between the monetary values of the Current Period and the Compared Period.
Furthermore, a variable denoted as $Threshold is utilized as a numerical limiter, functioning as a cutoff criterion for filtering the tabular rows. The intended filter logic is predicated upon the following condition: should the absolute value of the calculated difference exceed the predefined threshold, the corresponding row shall be retained; otherwise, it shall be omitted.
However, the predicament lies in the fact that, despite my implementation efforts—employing various conditional logic (via IF statements) and dimensional restrictions—the filtering mechanism fails to operate as expected. Rather than excluding the non-compliant rows, the measures within those rows revert to null values, rendering the table ineffective for the desired outcome.
