Calculation of Ratio using Row

[ravi13]

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…

[dyagaty]

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

[ravi13]

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

[FtmhRahimi]

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

[ravi13]

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

[FtmhRahimi]

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.