I wonder if someone of you could help me to figure out how I can add a calculated value, coming out of the math formula node as a constant value to another table for further calculation.
As shown below, I’d like to extract the value of 1.199% and add it as a constant value to another table.
Target is that always the calculated percentage of the total row is the transferred constant value to another table.
By the way, I do struggle to find a solution to rename the row “Row0_dup_Row0_dup” to “TOTAL”.
If you have some idea for that as well, highly appreciated.
Basically you have to determine “How to find” the relevant row that holds the value you want to add. In the example provided (similar to your original table) I have chosen to keep only the rows with missing values.
Then you turn it into a variable and use that variable you just defined in the Constant Value Column node.
Hello Hans, hello Kowisoft!
Thank you both very much for your great help on my issue.
I implemented as shown, basically following Hans’s workflow.
It worked like a charm!