Page 1 of 1

Nested IIF Formulas

Posted: Tue Sep 26, 2017 3:37 pm
by laducd
Does the following IIF formula look correct? I am getting a 0 but should be receiving data for the last value.

{IIF(Closing_Balance.Day_25_Closing_Balance_Sum>0,Closing_Balance.Day_25_Closing_Balance_Sum,IIF(Closing_Balance.Day_24_Closing_Balance_Sum>0,Closing_Balance.Day_24_Closing_Balance_Sum,IIF(Closing_Balance.Day_23_Closing_Balance_Sum>0,Closing_Balance.Day_23_Closing_Balance_Sum,IIF(Closing_Balance.Day_22_Closing_Balance_Sum>0,Closing_Balance.Day_22_Closing_Balance_Sum,IIF(Closing_Balance.Day_21_Closing_Balance_Sum>0,Closing_Balance.Day_21_Closing_Balance_Sum)))))}

Re: Nested IIF Formulas

Posted: Tue Sep 26, 2017 8:56 pm
by Alex K.
Hello,

Please check the last IIF(), it has only two arguments.
If the issue still present, please send us a sample report with test data for analysis.

Thank you.