Table calculation (division) is showing a wrong result

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

0e8d3c8d-9506-42fc-82b7-5e6b70cbd8bd.png

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

Could somebody help me?

Thanks in advance.

0 2 812
2 REPLIES 2
Top Labels in this Space