I have 2 metrics on Explore which are showing two numbers for example:
Metric A Metric B
Now I need to divide Metric A with Metric B so I used Result Metric Calculation and added a new metric to divide the two numbers. Therefore Metric C is SUM(A) / SUM (B). The result should be 0.67 but on Explore the result is 1. When I tested out SUM (B) / SUM (A) the result is 2 which should be 1.5. So the question is,
Is there something that is making the number to round up?