Calculate Column While is empty

[Diego_Pin]

Hello Friends, How I can do the calc column while my Column (M) is empty?

[Palaniyappan (Palaniyappan P)]

Kindly try with this expression
int_value= yourdatatable.AsEnumerable.Sum(Function(x) If(IsNumeric(x(“yourcolumnname”).ToString.Trim),CDbl(x(“Value”).ToString.Trim),0))

Cheers @Diego_Pin

[Diego_Pin]

Hello @Palaniyappan, I use this function in a Assign?

[Palaniyappan (Palaniyappan P)]

yah exactly
@Diego_Pin

[Diego_Pin]

@Palaniyappan Friend In the final of function (CopyToDatable()) In my assign he take a error (Not is a double)

[Palaniyappan (Palaniyappan P)]

aaah
it was my bad
it will give you only a int32 value as output
int_value= yourdatatable.AsEnumerable.Sum(Function(x) If(IsNumeric(x(“yourcolumnname”).ToString.Trim),CDbl(x(“Value”).ToString.Trim),0))

Cheers @Diego_Pin

[Palaniyappan (Palaniyappan P)]

Kindly let know for any queries or clarification
Cheers @Diego_Pin