How to multiply two columns data into one (Formula)

#1

For example columnA = 2 columnB=5
columnC=columnAcolumnB
columnC=10
I need formula.
if i try this "#{numberone}#{numbertwo}" it conc

#2

Here is something you can try -

(field(“Column_1”)*field(“Column_2”)).round(2)

Schema-

{
“id”: 98168,
“num_rows”: 1000,
“file_format”: “csv”,
“name”: “forum”,
“include_header”: true,
“columns”: [
{
“name”: “Column_1”,
“null_percentage”: 0,
“type”: “Number”,
“min”: 1,
“max”: 500,
“decimals”: 2,
“formula”: “”
},
{
“name”: “Column_2”,
“null_percentage”: 0,
“type”: “Number”,
“min”: 1,
“max”: 100,
“decimals”: 2,
“formula”: “”
},
{
“name”: “Total”,
“null_percentage”: 0,
“type”: “Formula”,
“value”: “(field(“Column_1”)*field(“Column_2”)).round(2)”,
“formula”: “”
}
]
}