How To use Arithmetic operator using LINQ

[Gokul001 (Gokul Balaji)]

Hello Everyone, Hope you are doing good

I would like to present this post who are looking for the expressions related to Arithmetic operator Min | Max | Sum | Average

Introduction

Aggregate expressions are used to make calculations over a specific set of records. For example, to calculate the total Quantity of all records, or the total number of records in the dataset.

Sum operator

SUM function can be extremely useful to calculate the sum of the items in a list/Collection

LINQ Expression

(From d in BuildDt.AsEnumerable Where Not (isNothing(d(1)) OrElse String.IsNullorEmpty(d(1).toString.Trim)) Select v = CDbl(d(1).toString.Trim)).Sum(Function (x) x)

Output

Average operator

The AVERAGE function can be used to find the average value of the items in a list/Collection.

LINQ Expression

(From d in BuildDt.AsEnumerable Where Not (isNothing(d(1)) OrElse String.IsNullorEmpty(d(1).toString.Trim)) Select v = CDbl(d(1).toString.Trim)).Average(Function (x) x)

Output

Minimum operator

MIN function can be used to find the minimum value in a list/Collection

LINQ Expression

(From d in BuildDt.AsEnumerable Where Not (isNothing(d(1)) OrElse String.IsNullorEmpty(d(1).toString.Trim)) Select v = CDbl(d(1).toString.Trim)).Min(Function (x) x)

Output

Maximum operator

MAX function can be used to find the maximum value in a list/Collection.

LINQ Expression

(From d in BuildDt.AsEnumerable Where Not (isNothing(d(1)) OrElse String.IsNullorEmpty(d(1).toString.Trim)) Select v = CDbl(d(1).toString.Trim)).Max(Function (x) x)

Output

You can find the sample workflow here

LINQ_ArithmeticOperator.xaml (9.3 KB)

Reference

[HowTo] LINQ - First Start # Min | Max | Sum | Average Operator

This HowTo gives an introductory overview of the aggregation Operators: Min, Max, Sum, Average Introduction The aggregation operators are used to retrieve from a collection a particular result by setting the contained items into a relationship. Overview I – Input P – Processing O – Output {2,12,-8,6,14,5} get the lowest value -8 {2,12,-8,6,14,5} get the highest value 14 {2,12,-8,6,14,5} sum up all values 31 {2,12,-8,6,14,5} get the average of all values 5.17 Constraints P…

Hope this will be helpful

Questions

For questions on your retrieval case open a new topic and get individual support

Feedback

Click button to share your thoughts

Regards
Gokul

[raja.arslankhan]

@Gokul001 Nice

[Gokul_Jayakumar (Gokul Jai)]

I’m Appreciating you for Knowledge Sharing