Calculate the SUM, COUNT, AVERAGE, MAX, MIN

Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/powerapps-collections-cookbook/calculate-the-sum-count-average-max-min/. Author: Matthew Devaney.

Calculate the SUM, COUNT, AVERAGE, MAX, MIN Input collection: myTravelExpenses11 Date Item Value 1/1/2020 Hotel 1050 1/1/2020 Food 30 1/2/2020 Food 75 1/3/2020 Hotel 1300 1/3/2020 Food 50 1/4/2020 Flight 800 Output value: SUM of Value 3305 Solution code: //Create a collection

ClearCollect(myTravelExpenses11, { Date : Date ( 2020 , 1 , 1 ), Item : "Hotel" , Value : 1050 }, { Date : Date ( 2020 , 1 , 1 ), Item : "Food" , Value : 30 }, { Date : Date ( 2020 , 1 , 2 ), Item : "Food" , Value : 75 }, { Date : Date ( 2020 , 1 , 3 ), Item : "Hotel" , Value : 1300 }, { Date : Date ( 2020 , 1 , 3 ), Item : "Food" , Value : 50 }, { Date : Date ( 2020 , 1 , 4 ), Item : "Flight" , Value : 800 } ); //Get the sum code Sum(myTravelExpenses11,Value) Code language: JavaScript ( javascript ) Output value: COUNT of Value 6 Solution code: //Get the count code CountRows(myTravelExpenses11) Code language: JavaScript ( javascript ) Output value: AVERAGE of Value 550.8333 Solution code: //Get the average code Average(myTravelExpenses11,Value) Code language: JavaScript ( javascript ) Output value: MAX of Value 1300 Solution code: //Get the maximum code Max(myTravelExpenses11,Value) Code language: JavaScript ( javascript ) Output value: MIN of Value 30 Solution code: //Get the minimum code Min(myTravelExpenses11,Value) Code language: JavaScript ( javascript )