Nested IIF Formulas
Posted: Tue Sep 26, 2017 3:37 pm
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)))))}
{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)))))}