Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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