Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show in a list box only those values which meet the condition?

Hi,

I want to display the names of people in the list box. But only those for which the sum of salaries for selected months is greater than the variable vSalary.

=If(Aggr(Sum(Monthly_Salary),Name)>=vSalary,Name)

Could you please help me. Thank you in advance.

1 Reply
Anonymous
Not applicable
Author

You may use this script in List box's expression.

Go to List Box object --> Click on field drop down --> Scroll extremely down --> You may see "<Expression>" option --> Click on it and copy/paste your above script.

Thanks