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.
Have a look at the AVG, Count, Sum Operators
This HowTo gives an introductory overview of the aggregation Operators: Min, Max, Sum, Average
The aggregation operators are used to retrieve from a collection a particular result by setting the contained items into a relationship.
I – Input
P – Processing
O – Output
get the lowest value
get the highest value
sum up all values
get the average of all values
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)
Is anyone going to help here?
Please find the below xaml for your reference
BlankProcess14.zip (70.2 KB)
Percentage divison and rank data.xlsx (8.6 KB)
Hope this helps!!