# Calculation of Ratio using Row

**URL:** <https://forum.knime.com/t/calculation-of-ratio-using-row/24180>\
**Category:** KNIME Analytics Platform\
**Created:** [May 28, 2020, 5:23am UTC](https://forum.knime.com/t/calculation-of-ratio-using-row/24180 "2020-05-28T05:23:32Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![ravi13](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ravi13/32/71358_2.png) [@ravi13](https://forum.knime.com/u/ravi13)\
**Post date:** [May 28, 2020, 5:23am UTC](https://forum.knime.com/t/calculation-of-ratio-using-row/24180/1 "2020-05-28T05:23:32Z")

</div>

Hi !! Knime Experts  
Hope You are doing well.

I am facing following issue…

I want to get “Cash flow margin ratio”

Where “Cash flow margin ratio” = Cashflow from operating activity / Revenue from operation

Cash from operating activity= Cash & Bank balance - Total other non operating income - total non current liability

I have following table… How can i make subtraction using this table…

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/0/30d36353055db2b2d677e364e819b878e9e7e5d2.png)

---

<div class="post-metadata">

**Author:** ![dyagaty](https://forum-cdn.knime.com/user_avatar/forum.knime.com/dyagaty/32/16890_2.png) [@dyagaty](https://forum.knime.com/u/dyagaty)\
**Post date:** [May 28, 2020, 5:59am UTC](https://forum.knime.com/t/calculation-of-ratio-using-row/24180/2 "2020-05-28T05:59:18Z")

</div>

Did you try Math Formula ?  
NOTE: Make sure to convert to int or double.

 ![Screen Shot 2020-05-27 at 10.58.24 PM](https://forum-cdn.knime.com/uploads/default/original/3X/7/6/7682ffcc8306f4b0078b4ac6c440c7a336f7eb66.png)

---

<div class="post-metadata">

**Author:** ![ravi13](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ravi13/32/71358_2.png) [@ravi13](https://forum.knime.com/u/ravi13)\
**Post date:** [May 28, 2020, 6:29am UTC](https://forum.knime.com/t/calculation-of-ratio-using-row/24180/3 "2020-05-28T06:29:00Z")

</div>

Hi @dyagaty  
i want to perform this = Cash & Bank balance - Total other non operating income - total non current liability  
Column= Sum(Accum.bal. 31.3.18\_1)  
= 87.407-(-83.506)-(-0.269)  
=171.182

---

<div class="post-metadata">

**Author:** ![FtmhRahimi](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ftmhrahimi/32/19915_2.png) [@FtmhRahimi](https://forum.knime.com/u/FtmhRahimi)\
**Post date:** [May 28, 2020, 8:07am UTC](https://forum.knime.com/t/calculation-of-ratio-using-row/24180/5 "2020-05-28T08:07:51Z")

</div>

Hi @ravi13  
If first use the “Transpose” node, then use “Math Formula”, it works correctly. 🤔

 ![Capture](https://forum-cdn.knime.com/uploads/default/original/3X/0/d/0dd0513b5d031fd15e8780d88b94b7e33ff9e905.jpeg)

---

<div class="post-metadata">

**Author:** ![ravi13](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ravi13/32/71358_2.png) [@ravi13](https://forum.knime.com/u/ravi13)\
**Post date:** [May 28, 2020, 8:10am UTC](https://forum.knime.com/t/calculation-of-ratio-using-row/24180/6 "2020-05-28T08:10:46Z")

</div>

Hi!! @FtmhRahimi

if i am applying Transpose but column suffix will show me “?” and math function required “D” or “I”  
How to solve this issue…  
i can see you have solve using insert column but can you elaborate me further…

Thanks

---

<div class="post-metadata">

**Author:** ![FtmhRahimi](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ftmhrahimi/32/19915_2.png) [@FtmhRahimi](https://forum.knime.com/u/FtmhRahimi)\
**Post date:** [May 28, 2020, 8:32am UTC](https://forum.knime.com/t/calculation-of-ratio-using-row/24180/7 "2020-05-28T08:32:43Z")

</div>

Hi @ravi13  
By separating the first column, you can Split (with column splitter node) the original data into two parts and then “transpose” the remaining data (without the first column), finally by using the “Insert Column Header” (inserting the first data column from original data as “table dictionary” and transposed data as “Data table”) you reache the desired tab.

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [June 4, 2020, 8:47am UTC](https://forum.knime.com/t/calculation-of-ratio-using-row/24180/8 "2020-06-04T08:47:08Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
