Find Percentage, Status and Rank

[Jeeru_venkat_Rao]

Hello Friends,
Percentage divison and rank data.xlsx (8.9 KB)

I have a query, where I want to find percentage, status and rank as per screenshot. I can do it by formula method but I am looking for linq query or other methods. I want to print it in excel in one go.

Thanks in advance.

[ppr (Peter Preuss)]

Have a look at the AVG, Count, Sum Operators

[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 Perf…

The Rank can be found by Distinct and Lookup

For the status you need to specify a map of e.g. percentage and Status slot

Maybe some calculations are to be done seperate in adavance (e.g. Rank lookup)

[Jeeru_venkat_Rao]

Is anyone going to help here?

[lrtetala (Lakshman Reddy)]

Hi @Jeeru_venkat_Rao

Please find the below xaml for your reference

BlankProcess14.zip (70.2 KB)

O/P:

Percentage divison and rank data.xlsx (8.6 KB)

Hope this helps!!