Add calculated column from values of an item to that item

Questions
1

Hello,

I would like to add a column per item in an item list which is a calculated value between two columns I paste an API response as an example. I think a good approach would be to use the Function node, loop the items object and get the values and then divide them. In the example shared workflow I would divide tvl/cmcId and set this value in a new attribute / column.

Please share the workflow

Thanks!

2

Add a function item node with the following code.

item.calculation = item.tvl/parseInt(item.cmcId)
return item
Example workflow
3

Thanks! One last thing! I would like that the calculated field named mc/tvl. Is it possible?

4 
item["mc/tvl"]= item.tvl/parseInt(item.cmcId)
return item