Filter datatable by values in two colums

[Chrisguff12]

I need help filtering a data table.

I have a data table with two column's 'Total_Qty' and 'Min_qty'. I want to only show the records where the total qty is less then the min qty. I am getting an error with my current code. can you please let me know if i can fix this to make it work.

MY code

Filter('Configs Inventory App', Value(Min_Qty_Column1.Text) > Value(Total_Qty_Column2.Text))

 the error

[PTBBSolutions]

@Chrisguff12 

Can you share the code behind 'LowQtyItemsDataTable'.'Items'?

[Chrisguff12]

The code I provided is the only code I have on the data table under property 'Items'

Filter('Configs Inventory App', Value(Min_Qty_Column1.Text) > Value(Total_Qty_Column2.Text))

[PTBBSolutions]

@Chrisguff12 

What about the text input controls? Have you set any default properties to them, and if yes - please share the code.

[Chrisguff12]

I don't have any text inputs. I was going to also filter the table with a dropdown that would filter by the Category column. but i havent set that up yet.  

[PTBBSolutions]

@Chrisguff12 

Then what are Min_Qty_Column1 and Total_Qty_Column2 and whey are they coming from?

[Chrisguff12]

they are columns names in the data table. they reference the column in this table

[PTBBSolutions]

@Chrisguff12 

You are trying to filter the source from the output - this is causing a circular reference. If your columns are numeric, you don't need the Value() as well.

In the Filter statement, refer to the columns from the data source directly, without adding .text

[Chrisguff12]

Ok so I changed my code to Filter('Configs Inventory App',Total_Qty < Min_Qty)

Now when I type the Last ")" in the code shows that it is working, after a few seconds the string turns red and gives me this error.

do you know why its failing? 

[PTBBSolutions]

@Chrisguff12 

What is your data source? What are the types of these 2 columns?