Record filter

[dhanavindhan]

Hi Experts,

I want to apply filter by condition. Please see my image first,

ExportFree Days was my first option filter. Then I will choose the Exp free days is = (Less_than or Greater_than or Equal_To) from the dropdown select. From that conditonthe record should be filtered and need to be populated in the table. I don't know what type of expression i need to write and how to apply that to filter the records. Can anyone help me to fix this issue. Thankx in advance

Example:

If I choose 21 from then I choose Less_than 21 (It should bring records below 21 like (20,19,18,17,16,15...etc on the table.

Regards,

Dhana R

[shiveshsingh]

Can you share your app?

You need to create 2 variables which will be having values from your Listbox or input box

Then use that variable in your set expression

like Sum({<Day-= {"$(=VariableName)"}>}Sales) - - -  Please keep in mind the formatting.