# Calculation of Ratio using Row

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…

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

1 Like

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

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

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

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.

4 Likes

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