[Solved] Calculated Columns Divide By 0

[poet_byron]

I'm trying to use the following expression to avoid division by 0:

 

 

Expression<Func<UPSReport, double>> expression = u => ((u.U1 + u.G1 + u.C1) > 0 ? (u.Cl / (u.U1 + u.G1 + u.C1)) : 0);

It keeps coming out with just 0's.  How could this be resolved?

 

[Yavor Georgiev]

Hello Matthew,

 I think your expression should work. However, could you please test it out manually using the following code:

Expression<Func<UPSReport, double>> expression = u => ((u.U1 + u.G1 + u.C1) > 0 ? (u.Cl / (u.U1 + u.G1 + u.C1)) : 0);
var func = expression.Compile() as Func<UPSReport, double>;
foreach (var item in myDataItemsSource)
{
     System.Diagnostics.Debug.WriteLine(func(item));
}

 If you get only zeroes in the Visual Studio Output window, then I'm afraid you'll have to debug your model. Also, even though I can't see an error in your expression, perhaps it'd be best to set a breakpoint and examine its DebugView property of the expression in the Visual Studio debug visualizer to see if the compiler has interpreted your intent correctly.

All the best,
Yavor Georgiev
the Telerik team

[poet_byron]

This had to do with me not typecasting my variables to double:

Expression<Func<UPSReport, double>> expression = u => ((u.U1 + u.G1 + u.C1) > 0 ? (u.Cl / (u.U1 + u.G1 + u.C1)) : 0);

Changed to:

 

 

Expression<Func<UPSReport, double>> expression = ups => (ups.UPS + ups.Guests + ups.Cust_Svc) > 0 ? (double)ups.Closes / ((double)ups.UPS + (double)ups.Guests + (double)ups.Cust_Svc) : 0;

Now it works.  Thanks for your help.