Multiply value inside a table

Good evening,
I’ve been working on this problem all day, if anyone has any ideas!
I’m trying to do this:
I have fields value :

(tech::clean :3:0.5:min) (tech::cook :5:0.2:min)

I want a table that displays this and a total for the calc column :

technique time coef cal
clean 3 0.5 4.5
cook 5 0.2 6
Total time cal : 10.5

so i try:

TABLE WITHOUT ID
	split(tech, ":")[0] AS technique,
	split(tech, ":")[1] AS time,
	split(tech, ":")[2] AS coef,
	cal
WHERE tech
FLATTEN tech
FLATTEN sum(time+(time*coef)) AS cal
WHERE file.name = this.file.name

But it doesn’t work, so I don’t know how to sum up the whole ‘cal’ column.

thank you very much

Well, it almost works:

TABLE WITHOUT ID
	split(tech, ":")[0] AS Techniques,
	split(tech, ":")[1] AS temps,
	split(tech, ":")[2] AS coef,
	timing,
	total
WHERE tech
FLATTEN tech
FLATTEN sum((number(split(tech, ":"))[1])+((number(split(tech, ":"))[1])*(number(split(tech, ":"))[2]))) AS timing
FLATTEN sum(number(rows.timing)) AS total
WHERE file.name = this.file.name

but I can’t total the column…
If anyone has any ideas!
thank you