Get the Average between two values

[oappdev]

Good morning, Power Apps Community,

What is the best scenario to get an average value between two values? Shooting a blank today. 

[Overall score] / [Weighted score] = Cumulative score %

Thank you in advance.

[GeorgiosG · Accepted solution]

You can use the AVERAGE function, https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-aggregates

Average([Overall score],[Weighted score])

[oappdev]

Thank you, @GeorgiosG I forgot about that function. How can I now display decimal numbers as a percentage? 

[GeorgiosG · Accepted solution]

Hi @oappdev , you can multiply this by 100 or use the Text Function

Text(Average(…),“0%“)

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text

[oappdev]

Thank you again for your help @GeorgiosG