IIF Funtion with bool & integer varaibles
Posted: Thu Jan 06, 2022 1:01 pm
Hi,
I have the following integer variables, BasicSalaryFrom & BasicSalaryTo. I have a bool variable called AllBasicSalary. If the user selects AllBasicSalary I want the filter to retrieve all salary records and ignore any value entered in the two integer variables.
What will be the correct way of implementing this ? I tried the following,
Adding this filter does seems to be filtering records with 0 value.
Thank you
I have the following integer variables, BasicSalaryFrom & BasicSalaryTo. I have a bool variable called AllBasicSalary. If the user selects AllBasicSalary I want the filter to retrieve all salary records and ignore any value entered in the two integer variables.
What will be the correct way of implementing this ? I tried the following,
Code: Select all
Bonus.Basic_Salary >= BasicSalaryFrom || AllBasicSalary
Bonus.Basic_Salary <= BasicSalaryTo || AllBasicSalary
Thank you