not null
Posted: Fri Oct 13, 2017 3:54 pm
How would I create an if formula with not null? Basically I have the formula below that says not = to 0. However that 0 is a null value.
{IIF(Closing_Balance.Day_5_Closing_Balance_Sum!=0,Closing_Balance.Day_5_Closing_Balance_Sum,IIF(Closing_Balance.Day_4_Closing_Balance_Sum!=0,Closing_Balance.Day_4_Closing_Balance_Sum,IIF(Closing_Balance.Day_3_Closing_Balance_Sum!=0,Closing_Balance.Day_3_Closing_Balance_Sum,IIF(Closing_Balance.Day_2_Closing_Balance_Sum!=0,Closing_Balance.Day_2_Closing_Balance_Sum,Closing_Balance.Day_1_Closing_Balance_Sum))))}
{IIF(Closing_Balance.Day_5_Closing_Balance_Sum!=0,Closing_Balance.Day_5_Closing_Balance_Sum,IIF(Closing_Balance.Day_4_Closing_Balance_Sum!=0,Closing_Balance.Day_4_Closing_Balance_Sum,IIF(Closing_Balance.Day_3_Closing_Balance_Sum!=0,Closing_Balance.Day_3_Closing_Balance_Sum,IIF(Closing_Balance.Day_2_Closing_Balance_Sum!=0,Closing_Balance.Day_2_Closing_Balance_Sum,Closing_Balance.Day_1_Closing_Balance_Sum))))}