# How to get average of marks(subject wise)

**URL:** <https://community.automationedge.com/t/how-to-get-average-of-marks-subject-wise/2901>\
**Category:** Get Help & Discuss\
**Created:** [March 24, 2021, 9:01am UTC](https://community.automationedge.com/t/how-to-get-average-of-marks-subject-wise/2901 "2021-03-24T09:01:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![shubham\_p](https://avatars.discourse-cdn.com/v4/letter/s/b9bd4f/32.png) [@shubham\_p](https://community.automationedge.com/u/shubham_p)\
**Post date:** [March 24, 2021, 9:01am UTC](https://community.automationedge.com/t/how-to-get-average-of-marks-subject-wise/2901/1 "2021-03-24T09:01:14Z")

</div>

**Problem** : I’m trying to get average of math\_marks(column)  
Through group by I have done it but it is repeated in each rows. kindly see snapshot  
I want average of MATH marks below the column

 ![problem](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/6aee1838d76f6e703c34b1a8c3f38009fb5d0e79.png) .

---

<div class="post-metadata">

**Author:** ![Imran\_Bhole](https://avatars.discourse-cdn.com/v4/letter/i/b9e5f3/32.png) [@Imran\_Bhole](https://community.automationedge.com/u/Imran_Bhole)\
**Post date:** [March 25, 2021, 6:47pm UTC](https://community.automationedge.com/t/how-to-get-average-of-marks-subject-wise/2901/2 "2021-03-25T18:47:52Z")

</div>

Hi Shubham,

We request you to kindly use block step. You can pass the Average Sum of last row.

If you need and require result of last row then please use block step and then you will get last row.

---

<div class="post-metadata">

**Author:** ![shubham\_p](https://avatars.discourse-cdn.com/v4/letter/s/b9bd4f/32.png) [@shubham\_p](https://community.automationedge.com/u/shubham_p)\
**Post date:** [March 26, 2021, 10:46am UTC](https://community.automationedge.com/t/how-to-get-average-of-marks-subject-wise/2901/3 "2021-03-26T10:46:08Z")

</div>

can we you describe in details? Because I could not understood how to use block step