not null

Stimulsoft Reports.Web discussion
Post Reply
laducd
Posts: 115
Joined: Thu Oct 23, 2014 2:15 pm

not null

Post by laducd » 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))))}
Edward
Posts: 2907
Joined: Fri Jun 09, 2006 4:02 am

Re: not null

Post by Edward » Fri Oct 13, 2017 10:39 pm

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
Posts: 115
Joined: Thu Oct 23, 2014 2:15 pm

Re: not null

Post by laducd » Tue Oct 31, 2017 4:33 pm

perfect thanks
Alex K.
Posts: 6476
Joined: Thu Jul 29, 2010 2:37 am

Re: not null

Post by Alex K. » Tue Oct 31, 2017 7:50 pm

Hello

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

Thank you.
Post Reply