topic AVG of values Per MPG in App Development

AVG of values Per MPG

waleeed_mahmood — Sat, 16 Nov 2024 01:22:56 GMT

Hello,

I hope you are doing well.

I have the following table:

Im trying find the avg of every MPG. so my resulting table would look something like this:

And i cannot get those numbers for the life of me. I am getting 5.58 for 4J. I have no other table in my app. Just that table.

Thank you.

Taoufiq_Zarra — Sat, 26 Sep 2020 09:21:24 GMT

this is what I get :

check if you have decimal values in Change like 5.002454... instead of 5 !

Kushal_Chawda — Sat, 26 Sep 2020 11:14:59 GMT

@waleeed_mahmood Looks like you have decimal numbers in your Change column. Rounding of Change column can help you to get the same number . Try below

= avg(floor(Change))

=avg(round(Change))

ramchalla — Sat, 26 Sep 2020 12:24:41 GMT

you can try the below code.

Test:

LOAD
Owner,
MPG,
MC,
Change
FROM [lib://dvSourceDataPath/ICO_Recharges_MI/Test/Book1.xlsx]
(ooxml, embedded labels, table is Sheet1);

Left Join (Test)
Test_Avg:
Load

Owner,
MPG,
Avg(Change) as ChangeAvg

Resident Test
Group By
Owner,
MPG,
;