Calculate average of values in a row

Hi Guys

I have transactional data that I am trying to analyze.

1. I am trying to get the average number of transactions that happened for each row.

- Basically in excel I would paste the table and then apply the Autosome average and drag down to get average for each row. The average would be in the last column.

2. Then I want a count of the Values that exceed the average for each row.

Sample Dataset to work with.xlsx

Data Investigation

Accepted answers

IraWatt

Hey @Sakhile,

You can get the average number of transactions like this:

And count the number greater then average like this:

If you have any questions make sure to ask

HTH,

Ira

Average Transactions.yxmd

grazitti_sapna

Hi @Sakhile , another way of solving this problem, please mark this post as a solution if it works!

Sakhile _workflow.yxmd

All comments

IraWatt

Hey @Sakhile,

You can get the average number of transactions like this:

And count the number greater then average like this:

If you have any questions make sure to ask

HTH,

Ira

Average Transactions.yxmd

grazitti_sapna

Hi @Sakhile , another way of solving this problem, please mark this post as a solution if it works!

Sakhile _workflow.yxmd

Sakhile

Hi @IraWatt and @grazitti_sapna

Both your solutions have resolved my problem. Thank you both very much !!!!!!!!!!!!!!!!!!!

IraWatt

No worries @Sakhile! glad it worked for you also if @grazitti_sapna's solution worked for you your able to give both answers the solution tick

Sakhile

@grazitti_sapna IraWatts solution was simpler and easier to understand and reperform hence why I accepted his.

grazitti_sapna

@IraWatt, I appreciate your recommendation. Thanks! 🙂

@Sakhile - No problem there are multiple ways of solving a problem, glad both worked for you!

Thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703