Total of column is coming wrong. We need to do calculation first row wise then make sum of values

[rohit_shoppertr]

Hi team,

We have a use case where we are multiplying three columns and show the outcome. Problem here is we need to do the multiplication by row and then add the total but what is happening first column total is happening then multiplication is happening.

ColumnA	Column B	Column C		Multiplication result Row wise(A*B*C)
1	0.7	25		17.5
1	0.3	15		4.5
1	0.2	27		5.4
1	0.07	179		12.53
1	0	0		0
1	0	0		0
1	0	0		0
1	0	0		0
1	0	0		0
1	0	0		0
1	0	0		0
1	0	0		0
1	0	0		0
1	0	0		0
1	0	0		0
1	0	0		0
1	0	0		0
17	1.27	246	Sum of Column (Multiplication result(A*B*C))	39.93
Output of (17*1.27*246)
5311.14

We are expecting 39.93 as result but result is coming 5311 because looker first making sum of entire column then multiplying the results.

Question is how to do multiplication or calculation first row wise then make total or sum