Table calculation (division) is showing a wrong result

[cgerauy]

Hi Looker team,

I’ve set up a metric in Looker Studio called ROI = (x - y) / y

The result is wrong, i.e. In the image in the first row should be = 0.0527 instead o 7,33

Furthermore, the result of 1/y it´s also wrong but y/100 gives the right answer.

Could somebody help me?

Thanks in advance.

[ernestofacal777]

any solution for this? the same problem here

[laurencebn]

I think this the wrong forum for Looker Studio questions?

But I think the solution is to use the SUM() function in your formula:

( SUM(recupero) - SUM(total_cost) ) / SUM(total_cost)