Nested IIF Formulas

[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)))))}

[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.