I’ve got a problem with the solution provided in this post. Creating a new topic since the original post is closed.

The query doesnt not provide the correct value all the time. Am I missing something. Please help

@vickydas

I’ve got a problem with the solution provided in this post. Creating a new topic since the original post is closed.

The query doesnt not provide the correct value all the time. Am I missing something. Please help

@vickydas

The sum of the above value is 0. But the query result is 2.91038304567337E-11

Below is the query used:

dt_t1.AsEnumerable.Sum(Function ® If(IsNumeric(r(“Column13”).ToString.Trim), CDbl(r(“Column13”).ToString.Trim), 0))

@chenderson Can you please help?

Hi,

If i see correctly above values gives a sum of 1.2 not 0, and you can change Double type value to Decimal. Decimal type should be use for financial operations.

The decimal keyword indicates a 128-bit data type. Compared to floating-point types, the decimal type has more precision and a smaller range, which makes it

appropriate for financial and monetarycalculations.

So query you should use is: dt_t1.AsEnumerable.Sum(Function ® If(IsNumeric(r(“Column13”).ToString.Trim), CDec(r(“Column13”).ToString.Trim), 0))

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.