Analytic Apps to filter Amount above Threshold

Question

Hello,

I want to ask if how can I configure my interface tool to enable me to filter amounts greater than a threshold. For example below and in the attached file, I have a custom filter for amounts >= 40000 or <= -40000. Amounts >= the absolute amount of 40,000 must be filtered regardless of it is negative or positive. I connected a text box tool for this to allow user to enter any amounts for threshold. I tried the configuration below but it returns amounts even lower than the absolute amount for 40000. I filtered the source check and 40000 as absolute amounts however, it returned me the source for deposit.

To summarize, it is desired that we will filter the source column as well as amounts greater than 40000 (absolute be it negative or positive).

Thank you.

Analytic Apps for JE.yxwz

DawnDuong · Accepted Answer

hi @Gamaliel

I will try to solve it slightly differently.

Create a new column called "Threshold" and set it to text value of "40000".

Use an interface tool to allow user to specify an amount. and link the interface tool to the formula tool to update the value.

Set your filter condition

abs([Amount]) <tonumber([Threshold])

then you should get the desired result.
Dawn.

Gamaliel · Accepted Answer

Thanks @DawnDuong . I also tried this one in the filter

[Net Amount] >= 40000 || [Net Amount] <= -40000

and it also works.