# Single row calculation

**URL:** <https://forums.knack.com/t/single-row-calculation/12234>\
**Category:** Get Answers\
**Created:** [March 15, 2022, 12:25am UTC](https://forums.knack.com/t/single-row-calculation/12234 "2022-03-15T00:25:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![RONALD](https://avatars.discourse-cdn.com/v4/letter/r/ea666f/32.png) [@RONALD](https://forums.knack.com/u/RONALD)\
**Post date:** [March 15, 2022, 12:25am UTC](https://forums.knack.com/t/single-row-calculation/12234/1 "2022-03-15T00:25:44Z")

</div>

Hi everyone, is it possible to have an equation individually by row in a table? So I have sample excel here that each row are having different formula. Thanks in advance 🙂

![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/7/7f27c16fe453a921d9b0a3ea2a0fdf32c5b4a206.png)

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [March 15, 2022, 6:18am UTC](https://forums.knack.com/t/single-row-calculation/12234/2 "2022-03-15T06:18:47Z")

</div>

Hey @RONALD - As you are aware, database tables store data in rows so you can’t do calculations the same way as you can in columns in a spreadsheet. Each field in a table is in effect a column and can only have one equation / formula. There may be another way to create the solution that you are looking for but you can’t replicate the functionality of a spreadsheet in this way.

---

<div class="post-metadata">

**Author:** ![RONALD](https://avatars.discourse-cdn.com/v4/letter/r/ea666f/32.png) [@RONALD](https://forums.knack.com/u/RONALD)\
**Post date:** [March 22, 2022, 6:48am UTC](https://forums.knack.com/t/single-row-calculation/12234/3 "2022-03-22T06:48:18Z")

</div>

Thanks as always @CarlHolmes. You are awesome and very much valuable to the community!

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [March 22, 2022, 7:41am UTC](https://forums.knack.com/t/single-row-calculation/12234/4 "2022-03-22T07:41:27Z")

</div>

@RONALD - thank you for your very kind words, it’s greatly appreciated 🙏