Numerator/Denominator - incorrect value in Numeric Display
My calculation is SUM(Numerator*1.0)/SUM(Denominator*1.0). You can do the same calculation with division of columns.
Do the math:
568973/393468 = 1.44
However, when I pull my calculation over - an aggregation type must be selected and all of the aggregation types give the wrong value. If I select average (which is the closest) - it gives me 1.49. It's doing an average of averages.
I don't want to use any of those aggregation types - How do I get it to display 1.44 not 1.49?