not null

[laducd]

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

[Edward]

Hi Laducd,

Please check out the following post: viewtopic.php?t=2265

And then please try to replace every value in your expression as follows:

Closing_Balance.Day_5_Closing_Balance_Sum!=0
to
Closing_Balance["Day_5_Closing_Balance_Sum"] == DBNull.Value ? 0 : Closing_Balance.Day_5_Closing_Balance_Sum != 0

Thank you,
Edward

[laducd]

perfect thanks

[Alex K.]

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.