Pradees
Pradees

Reputation: 201

How to calculate sum() column from dynamic list?

I have a dynamic list that is given below;

var CashReceiptDailyCollectionDetails = new List<dynamic>();

In the above list having TotalAmount column; How to calculate Sum of TotalAmount by using linq query from dynamic list. I was tried like below query; but it gives object referance error.

CashReceiptDailyCollectionDetails.Sum(x => Convert.ToDecimal(x.TotalAmount))

Upvotes: 0

Views: 344

Answers (1)

Ioannis G.
Ioannis G.

Reputation: 250

decimal holdingNum = -1;
            var decimalsSums = CashReceiptDailyCollectionDetails.
                Select(o => o != null ?( string.IsNullOrEmpty(o.ToString()) == false?
            (decimal.TryParse(o.ToString(), out holdingNum) == true ?
            holdingNum : 0) : 0):0).Sum();

Upvotes: 1

Related Questions