=IF( AND(Salary_Calculation="Y",SUM(salary_tbl10.Actual_Salary_New_Value)=0,SUM(salary_tbl08.Checks_Remaining_New_Value)=0), SUM(salary_tbl10.Actual_Salary)/SUM(salary_tbl08.Checks_Remaining), IF( AND(Salary_Calculation="Y",salary_tbl10.Actual_Salary_Change_Value.Yes,SUM(salary_tbl10.Actual_Salary_New_Value)>0,SUM(salary_tbl08.Checks_Remaining_New_Value)=0), SUM(salary_tbl10.Actual_Salary_New_Value)/SUM(salary_tbl08.Checks_Remaining), IF( AND(Salary_Calculation="Y",salary_tbl08.Checks_Remaining_Change_Value.Yes,SUM(salary_tbl10.Actual_Salary_New_Value)=0,SUM(salary_tbl08.Checks_Remaining_New_Value)>0), SUM(salary_tbl10.Actual_Salary)/SUM(salary_tbl08.Checks_Remaining_New_Value), IF( AND(Salary_Calculation="Y",salary_tbl08.Checks_Remaining_Change_Value.Yes,salary_tbl10.Actual_Salary_Change_Value.Yes,SUM(salary_tbl10.Actual_Salary_New_Value)>0,SUM(salary_tbl08.Checks_Remaining_New_Value)>0), SUM(salary_tbl10.Actual_Salary_New_Value)/SUM(salary_tbl08.Checks_Remaining_New_Value), SUM(salary_tbl10.Actual_Salary)/SUM(salary_tbl08.Checks_Remaining)))))
I am running the following script. However, I need assistance with finding out how to run a condition for when a checkbox is not set. The checkbox only has one value. I would want to run a calculation when the value is unchecked.
I am hoping I do not have to switch my fields to radio buttons as that is the only possible solution that may resolve this.
Also, I am unable to get IFS() function to work.