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.
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)
If first use the “Transpose” node, then use “Math Formula”, it works correctly.
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…
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.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.