Divide by Zero Exception inside of a Linq Join Condition

Question

Divide by Zero Exception inside of a Linq Join Condition

lesponce 176

Give the example below, I'm getting a Divide by Zero exception error. Can you please advise me how to set the Result value to zero if the data in field test1 is zero?
I can't use at "try catch" of "if statement" because the code that is doing the calculation is inside of a linq join condition. Thanks for your help.

            decimal? Result = 0;  
            decimal? test1 = 0;  
            decimal? test2 = 57;  
  
   
           Result = (decimal)(test1 == null ? 0 : ((test2 - (test1 ?? 0)) / test1));

Accepted answer

1 additional answer

Your answer

Answer 1

Bruce (SqlWork.com) 77,766 Volunteer Moderator

simple:

Result = (decimal)((test1 == null || test1 == 0) ? 0 : ((test2 - (test1 ?? 0)) / test1));

Answer 2

lesponce 176

Hi Bruce, thanks for your response. If test2 is null, I get this error: Nullable object must have a value.

Bruce (SqlWork.com) 77,766 Reputation points Volunteer Moderator

2022-09-07T22:11:40.89+00:00

then coalesce like test 1 or just guard:

Result = (test1 == null || test1 == 0 || test2 == null) ? 0 : (test2 - test1) / test1;

Share via

Divide by Zero Exception inside of a Linq Join Condition

1 additional answer

Your answer